Percentage Margin Formula

Hi Shg

Thanks for your reply & welcome

I tried the example 1

however when I enter 40% in the cell B21 it automatically changes the value to £0.41 insted of showing 40%

and when I put the formula in B20 it gives an circular reference warning and puts in the value as £0.00

My table is set as below:

A- B
19 Cost ___________ £54
20 Sell Price_______ ?
21 Margin_________ 40% ( however when I put in 40% it sets to £0.41 automatically)

See attached.