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
Bookmarks