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

"Bernard Liengme" wrote:

=IF(your_formula=0,"",your_formula)
then me know if you understand.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Cosmo" wrote in message
...
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
$-
$-
$-
$-
$-
$-