Formula Formatting
 

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

Formula Formatting
 

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

Formula Formatting
 

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

Formula Formatting
 

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)
--
David Biddulph

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

Formula Formatting
 

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

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

Cosmo wrote:

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





--

Dave Peterson