Forum Discussion

ISsaafdn's avatar
ISsaafdn
Copper Contributor
Mar 24, 2022

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

    • ISsaafdn's avatar
      ISsaafdn
      Copper Contributor

      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

Resources