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.

hi,
yes, something like this might work.

=IF(AND(C20="",C24=""),0,SUM(C30:C31))

regards
FSt1
"Mike Busch" wrote:

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.