Formulas Please

[Guest]

I hope this isn't a silly question, but I'm new with Excel and can't find an
answer...
I'm after a formula that will calculate a buy price where I know the final
retail price and margin (eg: $? + 40% = $149, $? + 40% = $299). I want to be
able to enter a retail price and margin to calculate the buy price.
Also, a formula that will calculate the profit margin where I know the buy
and sell prices (eg: $200 + ?% = $400, $150 + ?% = $250). I want to be able
to enter buy and sell prices and calculate the profit margin.
Thanks!

 

[Bob Phillips]

I hope this isn't a silly question, but I'm new with Excel and can't find an
answer...
I'm after a formula that will calculate a buy price where I know the final
retail price and margin (eg: $? + 40% = $149, $? + 40% = $299). I want to be
able to enter a retail price and margin to calculate the buy price.

Price in A1, margin in B1,
C1: =A1*(1+B1)

Also, a formula that will calculate the profit margin where I know the buy
and sell prices (eg: $200 + ?% = $400, $150 + ?% = $250). I want to be able
to enter buy and sell prices and calculate the profit margin.

Buy price in A1, sell price in B1
C1: =(B1-A1)/A1 and format as percentage

 

[Guest]

Thanks for your help Bob!

Price in A1, margin in B1,
C1: =A1*(1+B1)


Buy price in A1, sell price in B1
C1: =(B1-A1)/A1 and format as percentage