Percentage Margin Formula

**GRS123** · 10-13-2010, 07:43 PM

Hi there

I've almost got no hair left trying out formulas for this, hope someone can help!

1. Setting a percentage margin to set the sale value

example

Cell B19 is cost (value is filled in)
Cell B20 is selling price (value not filled in)
Cell B21 is percentage I want to put in to change the B20 value (for example 30% profit margin)

I need to know what needs to go in B21 to for it to show up as a % and what needs to go into B20 for it to automatically fill in the sale price

2. Percentage Margin

example

Cell B19 is cost (value is filled in)
Cell B20 is selling price (value filled in)
Cell B21 is percentage increase in cell B21 (value not filled in)

B21 needs to show up as a % so I can see what the margin in

Thank you for your time

**shg** · 10-13-2010, 07:56 PM

Welcome to the forum.

Please Login or Register  to view this content.

**GRS123** · 10-13-2010, 08:19 PM

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)