Forum Discussion
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> AN...
=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.