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!!