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