Hello everyone,

I am trying to create a spreadsheet that will calculate incentive payout based on a range of numbers. I need help with a formula!

For example:

METRIC 1
<89 = $0.00
89.00-96.16 = $50.00
96.17-97.17 = $100.00
97.18-98.99 = $150.00
>98.99 = $200.00

So basically, if I type 96.50 into cell C5, I need cell K5 to show $100.00, and so forth. I would need to change the data in cell C5 almost daily, so I always need cell K5 to change to the dollar amount automatically based on the number I input into C5.

I have no idea how to put this into a formula.

PLEASE HELP!!

Thanks :-)