Hey All,

First thanks for any help you can offer. I think I have the functions I need, I'm just not sure how to properly arrange them.

I want to create a sliding scale to calculate a product markup.

Anything under $5 is *2. Anything over $15 is *1.45. Everything inbetween is calculated based on price. I believe I need to use the forecast function on a table like below.

5 15
2 1.45

SO if my Cost" cell is A1 In my results cell I should have

=FORECAST(a1, $C$2:$D$2,$C$1:$D$1)

correct?