Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formulas
When I put in a formula for a total, how do I make it show up as blank
instead of a zero if there is only one variable listed. For example, I want to put a mileage rate in as a constant and I want the total cell to be blank instead of zero if there is no mileage number in the first cell. I'm using Excel 2003. Thanks. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formulas
=IF(A1="","",rest of formula)
Gord Dibben MS Excel MVP On Wed, 20 Jun 2007 15:29:38 -0700, Vi wrote: When I put in a formula for a total, how do I make it show up as blank instead of a zero if there is only one variable listed. For example, I want to put a mileage rate in as a constant and I want the total cell to be blank instead of zero if there is no mileage number in the first cell. I'm using Excel 2003. Thanks. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formulas
Here are two options...
I. Change your formula to look like this =IF(formula=0,"",formula) for example if your formula as it is now is this... =4*B1^2 then change it to this =IF(4*B1^2=0,"",4*B1^2) note that you can also use this... IF(B1=0,"",4*B1^2) II. Change the format of the cell containing the formula to something like this... General;-General; If you need more help, then please be more specific. Provide an example of cell values and the results you would like. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |