Mar 24 2022 01:39 PM
Hello!
Wishing anyone who reads this well! And to please help!
I'm struggling with trying to build this long formula.
So I have five specific values not listed in the exact order within 1 column:
A, B, C, D, E
I'm trying to make a rule that if:
A is equal to 200,000 or more, than it is TRUE
B is equal to or between 150,000 - 175,000 and/or 100,000 - 125,000 than it is TRUE
C is equal to or between 0 - 45,000 than it is TRUE
D is equal to or between 45,001 - 99,999 than it is TRUE
E is equal to or between 175,001 - 199,999, than it is TRUE
Basically the whole range is 0 - 200,000+ (infinity) but each letter has a specific range.
Any help would be greatly appreciated! Thank you so much!
Mar 24 2022 02:13 PM
Should all conditions be TRUE for the formula to return TRUE? If so:
=AND(A>=200000, OR(AND(B>=150000, B<=175000), AND(B>=100000, B<=125000)), AND(C>=0, C<=50000), AND(D>45000, D<100000), AND(E>175000, E<200000))
Mar 30 2022 06:18 AM
@Hans Vogelaar Thank you for your answer! I don't believe I explained my formula issue thoroughly, but was able to come up with a formula. I appreciate you responding however and for your help!
Best,
Ilsa