# 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

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)))

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

Make a table with the values in it.

After that use VLookup to find the values.

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

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

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

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

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1