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

New Contributor

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!

2 Replies

@ISsaafdn 

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!

 

Best,

Ilsa