Forum Discussion

Shea_Ripley's avatar
Shea_Ripley
Copper Contributor
Apr 14, 2023

HELP PLEASE!

I need to figure out how to create a formula that will do the following:

If the number entered in, lets say, A3 is 8> AND 12<, then the number "3" is returned.

If the number entered in A3 is 12> AND 16<, then the number "4" is returned.

If the number entered in A3 is 16> AND 20<, then the number "5" is returned.

If the number entered in A3 is 20> AND 24<, then the number "6" is returned.

If the number entered in A3 is 24> AND 28<, then the number "7" is returned.

 

Thank you for any insight!

  • Shea_Ripley 

    =IF(AND(A3>8,A3<12),3,IF(AND(A3>12,A3<16),4,IF(AND(A3>16,A3<20),5,IF(AND(A3>20,A3<24),6,IF(AND(A3>24,A3<28),7,"")))))

    If you don't have access to XLOOKUP you can try a nested IF formula.

     
  • Lorenzo's avatar
    Lorenzo
    Silver Contributor

    Shea_Ripley 

    Could you please revise the title of your post so that it better reflects your challenge (everybody who come here expect help) - Thanks

     

    =XLOOKUP(A3,{8,12,16,20,24,28},{3,4,5,6,7,"Outside"},"Outside",-1)

Resources