Price Curve Formula

**phildabone01** · 04-09-2009, 02:03 PM

Please Help!!

I'm trying Calculate Curved Price Rate by SF...

phil.freestyle@gmail.com

**shg** · 04-09-2009, 02:53 PM

Welcome to the forum.

So what should the answer be, $70.75, $55, or somewhere in between?

**phildabone01** · 04-09-2009, 03:24 PM

The price should be $55.16 @ 299 Sf .The Rate gradually lowers as the sq ft gets higher... There is a price curve for every hundred SF.. So I were to input 299 SF it should pull the price curve bewteen 200-300 and same for 300-400 & so on. I have a trendline line with the calculations I just don't know where to go from here.

**shg** · 04-09-2009, 03:45 PM

Add this function to the workbook:

Please Login or Register  to view this content.

Then in C12, =IF(B12<$B$4, C4, IF(B12>$B$9, $C$9, Linterp(B4:B9, C4:C9, B12) ))

**phildabone01** · 04-09-2009, 04:10 PM

Thanks for the help... I really appreicate the quick response...

**shg** · 04-09-2009, 04:19 PM

You’re welcome. Would you please mark the thread as Solved?

Click the Edit button on your first post in the thread

Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes