IF(AND(OR Statement
I need assistance with a formula.
=IF(AND(OR([Specialty]@row = "type1", [Monthly Average Billings]@row >= 50000), [Specialty]@row = "type2", [Monthly Average Billings]@row >= 30000),"Yes","No")))
Type1 meets 50000 = Yes / Type1 doesn't meet 50000 = No
or
Type2 meets 30000 = Yes / Type2 doesn't meet 30000 = No
Best Answer
-
@nhornCGT Sorry, had parenthesis in the wrong place. Try this
=IF(AND([Specialty]@row = "type1", [Monthly Average Billings]@row >= 50000), "Yes", IF(AND([Specialty]@row = "type2", [Monthly Average Billings]@row >= 30000), "Yes", "No"))
Answers
-
@nhornCGT =IF(AND([Specialty]@row = "type1", [Monthly Average Billings]@row >= 50000)), "Yes", IF(AND([Specialty]@row = "type2", [Monthly Average Billings]@row >= 30000), "Yes", "No")
You don't need the OR as you are just using this logic
Type1 meets 50000 = Yes / Type2 meets 30000 = Yes / No
-
Thank you for the response. I'm getting #unparaseable. When I remove the second statement, it works perfectly but does not seem like the second IF(AND statement.
I appreciate your help. Thoughts?
-
@nhornCGT Sorry, had parenthesis in the wrong place. Try this
=IF(AND([Specialty]@row = "type1", [Monthly Average Billings]@row >= 50000), "Yes", IF(AND([Specialty]@row = "type2", [Monthly Average Billings]@row >= 30000), "Yes", "No"))
-
Help Article Resources
Categories
Check out the Formula Handbook template!