G
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!
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!