Variable Pricing Formula

[Harquor]

Hello. I have a quote sheet that marks up my price by a certain percent. The way I have it set up now is for a 10% markup and I adjust it manually. C1 = .10, C2 is where I enter the cost, B2 = C1*C2, A2 = B2+C2.

I would like change this to vary the markup percent based on the cost. Ie. as the cost gets higher, I would like to lower the percentage at which I mark it up. For example: $1 - 200 is marked up 10%, $201 - $500 is marked up 8%, $501 - $1000 is marked up 5%, etc.

Is this possible to do so I am able to just enter a cost and excel will identify and adjust accordingly?

 

[Harquor]

Hi Harquor

No problem. You should be able to put the table anywhere in the spreadsheet you want and just reference the table.

For the example i provided above, if you copied the table into cell A1 with Cost as a header then the table range would be A2:B5.

Also just a note that i made the 201 into 200.01 as this is currency and i don't like leaving those gaps but of course this is your work so change if needed.

I did this and it tells me I've entered too few arguments?

Cost Increase
1.00 0.5
600.01 0.4
1500.01 0.3
4000.01 0.2
18000.01 0.1
25000.01 0.08

 

[Finalfight40]

Did you also include your first argument of the lookup formula which was C2 in the example