Don't Want Zero

[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

 

[Thomas]

Assume you mean A28,in B28 enter,
=if(a28 ="","",a28*0.8)

 

[John Wilson]

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

 

[John Wilson]

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

 

[Thomas]

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)

If A28 has a formula that returns "" it will evalulate to True.
I see your point though.

 

[Random]

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.

 

[John Wilson]

Thomas,

If A28 has a formula that returns "" it will evalulate to True.

Okay, I see your point too.

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

John