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