Siple formula with a twist
 

I have a simple formula for some friends that will input the correct sates
tax on two of 10 line items in a list. So it reads =(C20+C24)*.07. OK. Now
the line above the tax is a sum of the list, then the tax, and after is the
Total with tax. Lets say the subtotal line is C30, tax line is C31 and Total
line is C32. I made this into a template because it is opened every day. When
you open it you get the #Value in both the Tax and the Total cell because
nothing has been entered into the cells in the formula. Is there some way to
allow this tax and Toal cells to show $0 rather than the #value. Thanks in
advance.

Summing empty cells should show 0, the #VALUE would suggest one of the cells
has some formula generating an error.
--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mike Busch" wrote in message
...
I have a simple formula for some friends that will input the correct sates
tax on two of 10 line items in a list. So it reads =(C20+C24)*.07. OK. Now
the line above the tax is a sum of the list, then the tax, and after is
the
Total with tax. Lets say the subtotal line is C30, tax line is C31 and
Total
line is C32. I made this into a template because it is opened every day.
When
you open it you get the #Value in both the Tax and the Total cell because
nothing has been entered into the cells in the formula. Is there some way
to
allow this tax and Toal cells to show $0 rather than the #value. Thanks in
advance.