IF function - multiple formula required

**mikejackson** · 06-15-2013, 08:37 AM

Hi All,

Im trying to create an IF formula without any joy. It needs to do the following.....

If the number in a cell (lets say that cell is A1) is less than 5 then cell A2 must = 1
If the number in cell A1 is between 5 and 10.5 (inclusive of those numbers) then cell A2 must = 2
If the number in cell A1 is between 11 and 16 (inclusive of thoese numbers) then cell A2 must = 3
If the number in cell A1 is greater than 16 then cell A2 must = 4

Any thoughts or advice?

Thanks

Mike

**benishiryo** · 06-15-2013, 08:48 AM

hi Mike, welcome to the forum. what about 10.6 to 10.9? is it also possible A1 is less than 1 or empty? i didn't include those possibilities:
=IF(A1<5,1,IF(A1<=10.5,2,IF(A1<=16,3,4)))

**oeldere** · 06-15-2013, 08:48 AM

Make a table with the values in it.

After that use VLookup to find the values.

**popipipo** · 06-15-2013, 08:49 AM

Make a table with these number and then use the 'vlookup' function

**mikejackson** · 06-15-2013, 09:03 AM

Hey benishiryo,

Thats perfect and works a treat, thank you so much! To answer your question - A1 will never be less than 1 or empty. Also, the numbers being enteredt into cell A1 are in increments of 0.5. So numbers can only be (for example) 9, 9.5, 10, 10.5, 11 etc etc....

thanks again