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