N
nowfal
Hi,
I am using the following formula to blank a cell(M2). Bu
unfortunately while copying it is not treating as blank. so i wanted t
make sure or double the blank cell and make sure it is blank. Hop
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
nowfa
I am using the following formula to blank a cell(M2). Bu
unfortunately while copying it is not treating as blank. so i wanted t
make sure or double the blank cell and make sure it is blank. Hop
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
nowfa