Multiple IF, AND, OR help please...

[aiki100]

Hello All -

Thanks so much for any ideas you might have on this:

I am trying to combine the following statements, each of which seem to work fine on its own, into one statement. Have googled, have searched here - surely I am missing something fundamental.

Many thanks for suggestions!

=IF((AND(K3="L",AG3="")),"",AG3-AD3)
=IF((AND(K3="S",AG3="")),"",(AG3-AD3)*-1)

 

[mrshl9898]

I don't follow.

What decides if you use AG3-AD3 or (AG3-AD3)*-1

 

[mrshl9898]

Also,

If you use either, it doesn't matter what's in K, as AG needs to be blank for it to TRUE, and it won't calculate if it is?

Sorry, I must be missing something. Happy to help if you could perhaps explain a few scenarios and what you want the result to be.

 

[fhqwgads]

maybe this?

=IF(NOT(AG3=""),IF(NOT(K3="L"),AG3-AD3,IF(NOT(K3="S"),(AG3-AD3)*-1,"")),"")

 

[aiki100]

Thank you all very much. Your thoughts greatly appreciated!

As it turns out, fhqwgads has an answer that worked, (although I had to reverse the L and S to get the math on my side correct - the formula worked perfectly, fhqwgads, I just didn't describe it well -- so sorry, my fault).

- I had not thought of using NOT that way (because I didn't know...) so thank you VERY much for the instructive here.

final outcome was this:
=IF(NOT(AG3=""),IF(NOT(K3="S"),AG3-AD3,IF(NOT(K3="L"),(AG3-AD3)*-1,"")),"")

Thank again to all -