ExcelBanter - If formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - If formula (https://www.excelbanter.com/excel-worksheet-functions/98111-if-formula.html)

dualshock

If formula

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.
I just started doing formulas yesterday so sorry if this one is really
simple and I'm just overlooking something.

[email protected]

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?

Casey

If formula

Try:

IF(AND(L34=0,F34=0),F35-L35, IF(F34=0,L34+F35,L35-F35)).

HTH

--
Casey

------------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
View this thread: http://www.excelforum.com/showthread...hreadid=559402

Sloth

If formula

=if(F34=0,IF(L34=0,-L35,L34)+F35,L35-F35)

"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.
I just started doing formulas yesterday so sorry if this one is really
simple and I'm just overlooking something.

dualshock

If formula

Thank you! This is exactly what I was trying to get.

"Casey" wrote:

Try:

IF(AND(L34=0,F34=0),F35-L35, IF(F34=0,L34+F35,L35-F35)).

HTH

--
Casey

------------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
View this thread: http://www.excelforum.com/showthread...hreadid=559402

All times are GMT +1. The time now is 03:10 PM.