Blank

[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

 

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

 

[nowfal]

Hi Dave,
I have got corrected by using zero inbetween the aphostphe.
Like this
=IF(J2="","0",IF(I2="S",CEILING(K2*L2,0.05),IF(I2="P",ROUNDDOWN(K2*L2/0.05,0)*0.05,"0")))
now the cell is not blank, but showing 0 (zero). Now iam thinking how
can i erase that zero. thats all
thanks
nowfa;

 

[RagDyeR]

You *can't* do what you're looking to do, create a *truly* blank cell that
contains a formula.

Could you explain exactly what you're trying to accomplish, so that perhaps
some "work-arounds" might be suggested?

I might take a guess here, since many questions pertaining to true blank
cells have something to do with creating charts and graphs.
If that's what you're looking for, a transparent (invisible) graph point,
try using the #N/A error.

Try this:

=IF(J2="",#N/A,IF(I2="S",CEILING(K2*L2,0.05),IF(I2="P",FLOOR(K2*L2,0.05),#N/
A)))

If I guessed wrong, try describing your ultimate goal.
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

message
Hi Dave,
I have got corrected by using zero inbetween the aphostphe.
Like this
=IF(J2="","0",IF(I2="S",CEILING(K2*L2,0.05),IF(I2="P",ROUNDDOWN(K2*L2/0.05,0
)*0.05,"0")))
now the cell is not blank, but showing 0 (zero). Now iam thinking how
can i erase that zero. thats all
thanks
nowfa;

 

[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,"")))

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.

 

[nowfal]

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