I am trying to build a formula that does the following:
The main formula for cell S8 is SUM(S4:S7)+S119
but if cell S9 and S119 both equal 0 then I need cell S8 to display $0.00 and ignore the main formula.
Also, if S9 equals 0 but S119 is greater than 0 then compute the main formula
Here are a few formulas I've tried but never the results I need
I've also tried ISBLANK instead of AND but that didn't work either.... Any help would be greatly appreciated!!
I was using http://www.techonthenet.com/excel/formulas/if_nested.php as my example but can't seem to figure it out.