If formula
dualshock wrote:
I am stuck trying to figure out a formula to use for my calculation. I'll try
to explain it the best I can.
Here is what I have so far: =if(F34=0,L34+F35,L35-F35). This formula works
just fine but I need to add another 'if' formula that has: if L34=0 and F34=0
then use F35-L35.
There are many ways to do anything. One way to accomplish what you
seem to want is:
=if(F34=0, if(L34=0, F35-L35, L34+F35), L35-F35)
PS: Should "L34+F35" [sic] be L35+F35?
|