I’m working on a spreadsheet and I can’t quite figure out the formula.
Column A has a price in it. The price is column B plus 13%. So B is the original cost, A is the cost that has been marked up 13%.
A=B+(B*13%)
The thing is I know the marked up price but not the original price. I need a formula to turn the 113% price into the 100% price.
Any ideas?
Wouldn’t it be the marked up price divided by 1.Markup percentage?
In your example, it would be 113/1.13
Or are you saying you don’t know the percentage either?
in the column for B
=(1/1.13)*A
Why wouldn’t that work? Or am I misunderstanding the question?
I know the percentage, it’s 13.
You’ve got it. Thanks, I just couldn’t get my brain into math mode this afternoon.
algebraically:
a=b+b*13%
'(100% of b is b)
a=b100% +b13%
a=b*113%
'divide both sides by 113%
a/113% = b
b = a/113%
or
b = a/1.13
Plug a few numbers in so you can see that it works.