Hello,
I'am looking for a formula that can take a range of numbers from one cell and output a specific figure, for example.
if A2 = (the range of numbers between 100 to 299) then answer is 3
if A2 = (the range of numbers between 300 to 499) then answer is 4
so in other words if i put the figure 105 in cell A2 then the answer would be 3
and also if i put the figure 405 in cell A2 the answer would be 4
I hope i explained this properly!
any help would be greatly appreciated
Thank you in advance,
Bookmarks