Formulas

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Vi - 20 Jun 2007 23:29 GMT

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.

Reply to this Message

Gord Dibben - 20 Jun 2007 23:42 GMT

=IF(A1="","",rest of formula)

Gord Dibben MS Excel MVP

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

Reply to this Message

Sloth - 21 Jun 2007 22:25 GMT

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 to this Message