Don't want zeros to show

[Jann]

I am filling a column with a simple formula:
=A13*D13
=A14*D14

How can I fix it so the zeros do not show when the there
is no quantity in A columns?
Thank you in advance. This community is fantastic!

 

[Dave R.]

Jann,


+IF(OR(A13=0,D13=0),"",A13*D13)

 

[ozzie]

Curious.

Couldn't she have set the format to accounting (with or
without a dollar sign) that way she will know there is
something numeric in the cell because she will see " - ".

Also, doesn't a formula increase the size and processing
time considerable more then specified formats?

 

[Dave R.]

This is probably a better way to do it, since I re-read now I think she
meant column A=0 and not "Columns"

if text should fall in to A or D and she doesnt want a #VALUE! message

+IF(OR(A13=0,ISERROR(A13*D13)),"",A13*D13)

if not--

+IF(a13=0,"",a13*d13)

but that will still show 0 if d is 0....

Yes formats save space here, but she wanted to know how to show a blank (non
numeric) if A is blank. If there were 0s where she wanted blanks, they (0s)
would count in averages and so forth.. so in her case it might be most
useful to have non numeric blanks there.

Dave