Forum Discussion
Formula Help! IFs/OR with a range of numbers to an extremely specific value
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...
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))
HansVogelaar 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