Blank

[nowfal]

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

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

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

"nowfal" <[email protected]> wrote in
message news:[email protected]...

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;


--
nowfal
------------------------------------------------------------------------
nowfal's Profile:
http://www.excelforum.com/member.php...o&userid=10003
View this thread: http://www.excelforum.com/showthread...hreadid=401674

[Dodo]

nowfal <[email protected]> wrote in
news:[email protected]:

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


--

It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)

[nowfal]

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