Formula Formatting

[Guest]

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
$-
$-
$-
$-
$-
$-

 

[Bernard Liengme]

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

 

[Guest]

how would I key that in? my formula is =sum(a4*1.2) so how do I add the =IF
to that

 

[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)

 

[Dave Peterson]

=if(a4="","",a4*1.2)

You don't need =sum() around that last portion.