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