Forum Discussion
Shea_Ripley
Apr 14, 2023Copper Contributor
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!
- OliverScheurichGold Contributor
=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.
- LorenzoSilver Contributor
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)