Excel Formula Help!! IF, THEN (maybe??) I'm clueless!

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 :-)

create a lookup value in any other cell with the following figures
89.00 $ 0.00
96.16 $ 50.00
97.17 $100.00
98.99 $150.00
1000000 $200.00

Then type the following formula in K5 =VLOOKUP(C5,LookupRange,2, TRUE)

please change your LookupRange with the cell you are setting your lookup table
hope it helps