You can use a Vlookup formula to do this. Instructions here
http://www.contextures.com/xlFunctions02.html#Range from Debra Dalgleish.

Hope this helps
Rowan

antonov wrote:
hello I have a question concerning a "if or" problem:
B20 is the cell where the value is inserted
if B20 = from 0 to 5200 then value in H20 = 47
if B20 = from 52001 to 26000 the H20 = 60
if B20 = from 26001 to 42000 then H20= 70
if B20=from 42001 to 105000 then H20=100
if B20 is over 105001 then H20 = 110
how can I achieve this in 1 formula?