Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 $- $- $- $- $- $- |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 $- $- $- $- $- $- |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 $- $- $- $- $- $- |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 $- $- $- $- $- $- |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting as a formula | Excel Worksheet Functions | |||
Formatting Within a Formula | Excel Discussion (Misc queries) | |||
Formatting with a Formula | Excel Discussion (Misc queries) | |||
Formula / Formatting Help - please!" | Excel Discussion (Misc queries) | |||
Formatting in the formula bar | Excel Discussion (Misc queries) |