If # falls in between a range then I want it to display a %

[sld1002]

We're implementing a sliding fee schedule and I'm trying to figure out if it's possible to automate the calculations.

For example, if someone is making $2,000/month, I would like to have the workbook look through the various levels (shown below) and indicate which is the % that should be used.

$1,628 $1,963 1% of Rate
$1,963 $2,298 2% of Rate
$2,298 $2,633 3% of Rate
$2,633 $2,968 7% of Rate
$2,968 $3,303 7% of Rate

I've been trying to come up with a formula but nothing seems to work. I'm hoping someone will be able to tell me if it's possible to do what I'm hoping to do.

[XOR LX]

Hi,

Assuming that the data you give is in cells A1:C5, and that the monthly wage for which you wish to return the % is in cell D1:

=INDEX($C$1:$C$5,MATCH(D1,$A$1:$A$5))

Regards

[Debraj Roy]

Try this too...

Please Login or Register  to view this content.

[sld1002]

Thank you so much!!! I was trying to use the If function. You have made my day and weekend!!!!

[XOR LX]

You're welcome.