Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Copy a Formula down with a Twist Q | Excel Worksheet Functions |