Hi,
I am using the following formula to blank a cell(M2). But
unfortunately while copying it is not treating as blank. so i wanted to
make sure or double the blank cell and make sure it is blank. Hope
anybody will help

=IF(J2="","",IF(I2="S",CEILING(K2*L2,0.05),IF(I2=" P",ROUNDDOWN(K2*L2/0.05,0)*0.05,"")))

thanks
regards
nowfal


--
nowfal
------------------------------------------------------------------------
nowfal's Profile: http://www.excelforum.com/member.php...o&userid=10003
View this thread: http://www.excelforum.com/showthread...hreadid=401674