I am after formulas for 2 cells in a spreadsheet.
Column A is a Cost price (derived from a report)
Column B is for a Sell Price
Column C is for the GP%
I want to be able to enter an amount into Column B that will give Column C the GP%. Also the reverse so that I change the figure in Column C it will adjust the Sell price in Column B.
Can anybody help with this?
edit - have added spreadsheet for better explanation 'Excel Form post example.xlsx'