How to Add Similar Formula in differnt Cell with $ (f4) condition?

[vj1030]

hi I want to copy below formual for next cell if i drag or copy past still the "$H3" continue to be same in next cell also,


=IF(I3/$H3>0,IF(I3/$H3<1,1,I3/$H3),0)


how can this be done?


Regards

Vj

 

[xld]

Try using $H$3

 

[vj1030]

Dear xld..

thanks its resloved..