Don't Want Zero

  • Thread starter Thread starter Pam
  • Start date Start date
P

Pam

I have a formula as follows:

=A28*0.8 in cell B28

If I do not enter anything in cell B28, I want B28 to be
empty instead of a zero.

ANY help would be greatly appreciated
 
Pam,

Did you mean A28????

If so, in cell B28, try the following:
=IF(A28=0,"",A28*0.08)

Another option:
Tools/Options/View and uncheck "Zero values"

John

John
 
Thomas,

Sometimes better to use
IF(A28=0)
which will evaluate to True for both a zero and a blank cell.
instead of
IF(A28="")
Which will evaluate to True only for a blank cell (not a zero)

John
 
John said:
Thomas,

Sometimes better to use
IF(A28=0)
which will evaluate to True for both a zero and a blank cell.
instead of
IF(A28="")
Which will evaluate to True only for a blank cell (not a zero)
Click to expand...

If A28 has a formula that returns "" it will evalulate to True.
I see your point though.
 
Did you mean something like:

=If(a28<=0,"",a28*.80)

If that is entered into b28 then it will remain blank until
a value greater than 0 is entered into a28.
 
Thomas,
If A28 has a formula that returns "" it will evalulate to True.
Click to expand...
Okay, I see your point too.

Maybe????:
=IF(OR(A28=0,A28=""),"Blank/Zero","Not Blank/Zero")

John
 
Back
Top