Formula Formatting

C

Cosmo

I am looking for some help with formulas. I have a price list with multiple
lines between each price. If I use a formula I get $0 answers on the blank
lines. Is there anyway to only get answers where there is data? Otherwise I
have to manually clear all the cells in between.

$2.34 $2.81
$-
$-
$-
$-
$-
$1.58 $1.89
$-
$-
$-
$-
$4.86 $5.84
$-
$-
$-
$-
$3.76 $4.51
$-
$-
$-
$-
$-
$-
$2.16 $2.60
$-
$-
$-
$-
$-
$-
 
B

Bernard Liengme

=IF(your_formula=0,"",your_formula)
then me know if you understand.
best wishes
 
D

David Biddulph

Why are you using SUM()? Have you looked at Excel help for the SUM()
function? What numbers are you trying to add? Why not just =A4*1.2?

To change that in the way Bernard suggest, use =IF(A4*1.2=0,"",A4*1.2)
Alternatives, to distinguish a real zero in A4 from a blank, would be
=IF(A4="","",A4*1.2) or =IF(ISBLANK(A4),"",A4*1.2)
 
Top