I an trying to total 3 formula totals even if information is not entered in all the formulas. If one had no input I get a #NA. Is there a way to put a zero as an answer to the formula and if info is entered the zero changes to the answer of the formula so I can get a total of all three formulas even if only one had input?
Bookmarks