Blank

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
 
D

Dave Peterson

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.
 
D

Dodo

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,"")))
Click to expand...

Put a 0 (zero, not "0") where you want nothing and suppress the display of
zeros?
That way you still can do calculations with "empty" cells.
 
N

nowfal

Hi Dedo,
Great idea, that works perfectly. thank you so much.
with regards
NOWFAL
 
Top