Nikki,

Why does $130k return a 2, why not a 3? Please explain the rules.

Mike

"Nikki" wrote:

Level Low High
1 $140,000 $155,000
2 $125,000 $155,000
3 $115,000 $145,000

How do I get a formula to look up a salary of $130,000 within the low and
high range to place the Level "2" into a cell?