Hi all
I am trying to find a formula for cell A3(sale price) that can be adjusted by entering a percentage in cell A2(margin) which will be the profit made from cell A1(cost price). Also I need 15% added to the value excluding the cost price.
For eg
A1 - £2.99
A2 - 20%
A3 - £3.58
I need to input into A2 to give me a value in A3 and also to add 15% onto the difference between A1 and A3 (£0.59 which will then be £0.69) into A3 to give the correct value of £3.68. I have tried doing this multiple cells but it doesn't add up. Hope this is easy to understand what I mean. Appreciate any help. Thanks.
I am trying to find a formula for cell A3(sale price) that can be adjusted by entering a percentage in cell A2(margin) which will be the profit made from cell A1(cost price). Also I need 15% added to the value excluding the cost price.
For eg
A1 - £2.99
A2 - 20%
A3 - £3.58
I need to input into A2 to give me a value in A3 and also to add 15% onto the difference between A1 and A3 (£0.59 which will then be £0.69) into A3 to give the correct value of £3.68. I have tried doing this multiple cells but it doesn't add up. Hope this is easy to understand what I mean. Appreciate any help. Thanks.
