asked on
How do you check for multiple possibilities in Excel
I have a spreadsheet with a list of ages. IF the age is 8 I want the adjacent cell to say 1km, or if 9 or 10 to say 2km and if 11 or 12 or 13 to say 3km. So age in H1 and distance in I1 depending upon age given
Microsoft ExcelMicrosoft Office
Last Comment
Saqib Husain
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
They are the only ones
Then above formula will work
ASKER
Perfect, thanks!
ASKER
All good. Thank you for the prompt help!
You'r Welcome Dier! Glad I was able to help
Although the question is closed, if the age ranges do not change then a much simpler formula could be used
=MIN(3,INT((H1-5)/2))
=MIN(3,INT((H1-5)/2))