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?
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?