Look in the help index for VLOOKUP

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Andmor" wrote in message
...
In cell D5 i have a figure that can varry in cell G5 i need a formula that
will do calculations depending on a range of values.

first $37,106 20.05%
over $37,106 up to $40,970 24.15%
over $40,970 up to $65,345 31.15%
over $65,345 up to $74,214 32.98%
over $74,214 up to $76,986 35.39%
over $76,986 up to $81,941 39.41%
over $81,941 up to $127,021 43.41%
over $127,021 46.41%


--
A.