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