# IF function - multiple formula required

1. ## IF function - multiple formula required

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

Thanks

Mike  Register To Reply

2. ## Re: IF function - multiple formula required

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)))  Register To Reply

3. ## Re: IF function - multiple formula required

Make a table with the values in it.

After that use VLookup to find the values.  Register To Reply

4. ## Re: IF function - multiple formula required

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

5. ## Re: IF function - multiple formula required

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  Register To Reply

6. ## Re: IF function - multiple formula required

Cool, thank you oeldere and popipipo....ill try that also  Register To Reply