Forum Discussion
Mark up calculator
I am not great at this. I want to start with a cost of a product $100 A5 add my over head variable say of 10% and show various profit margin % 0-100% What is the formula that should be in the ...
If I understand you correctly, here's one approach. You could adapt the formula (or modify it) to fit other layouts. I did this for modeling in a "what-if?" kind of way, where you can change any of the variables in cells A2, B2 and C2. The formula in D2 is
=A2*(1+B2)*(1+C2)The result looks like this with the variables shown