something is not adding up, G5 now equals 32.98 when it should equal
somewhere around $46,900
--
A.


"T. Valko" wrote:

Create a 2 column table like this:

0...20.05%
37106.01...24.15%
40970.01...31.15%
65345.01...32.98%
74214.01...35.39%
76986.01...39.41%
81941.01...43.41%
127021.01...46.21%

Assume that table is in the range A1:B8.

D5 = some number

Then:

=LOOKUP(D5,A1:B8)

--
Biff
Microsoft Excel MVP


"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.


.