Formula Help! IFs/OR with a range of numbers to an extremely specific value

New Contributor



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!

2 Replies


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

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