The first interval is 0 to 22.5 = 7200

Using your formula and table, if C1 = 13.5 the result is #N/A. The correct
result should be 7200.

The second interval is 22.6 to 23.8 = 6600

Using your formula and table, if C1 = 22.6 the result is 7200. The correct
result should be 6600.

Biff

"Mike H" wrote in message
...
why?

"T. Valko" wrote:

You need to use the lower boundary for each interval:

...........A............B
1........0.........7200
2.....22.6.......6600
3.....23.9.......????

Biff

"Mike H" wrote in message
...
I don't understand the rules sufficiently wher you say etc but it souns
like
you need a table of percentages/bonuses thus
A B
22.5 7200
23.8 6600
25.9 6200

You then lookup a value (say) 23.0 in C1 with this formula

=VLOOKUP(C1,A1:B3,2,TRUE)

C1 in this example will return 7200 until it increases to 23.8 after
which
it will return 6600.

Mike
"UnisourceforNPH" wrote:

I have a percentage (26.9%) that I need to compare to a table to see
what
amount of bonus my group receives.
(ie 0-22.5%=$7200, 22.6%-23.8%=$6600) and so on. So I need to be able
to
return a bonus value for whenever the percentage falls.