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

```
=if(S119=0,SUM(S4:S7)+S119,if(S119>0,SUM(S4:S7)+S119,if(S9=0,"$0.00")))
```

and

```
=if((S119)>0,SUM(S4:S7)+S119,if(AND((S119)=0),(S9=0),"$0.00"))
```

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.