HELP PLEASE!

[Shea_Ripley]

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!

[#2]

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

[#3]

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