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

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

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

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" wrote in
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;


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

nowfal wrote in
:

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)

Hi Dedo,
Great idea, that works perfectly. thank you so much.
with 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