Formulas can't return empty cells--the best that they can do is make a cell look
blank (using "").

I'm not sure what you mean about copy and treating it as blank, though.

nowfal wrote:

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

--

Dave Peterson