Help: Multiple IF formulas

[novumcollegium]

Hi,

I'm trying to create a formula that takes one of two courses of action, depending on the relationship between two variables.

In effect, I'm trying to combine the following two IF formulas:

1. =IF(AND(AG35="TRUE",Z35>AB35),AB35-Z35)

2. =IF(AND(AG35="TRUE",Z35<AB35),Z35-AB35)


Could someone point out the correct syntax?

Thank you!!

[alansidman]

=If (And(AG35="True",Z35>AB35),AB35-Z35, if(And(AG35="TRUE",Z35<AB35),Z35-AB35, Value if both If Statements are False))

[novumcollegium]

Thank you!

[mmmarks]

=if(and(ag35="true",z35>ab35),ab35-z35,
if(and(ag35="true",z35<ab35),z35-ab35))

[bebo021999]

Give a try:

Please Login or Register  to view this content.

Alternative formula:
Both cases, AB35-Z35 or Z35-AB35 will returns minus of the different

Please Login or Register  to view this content.