Calculate price from GM %

[matthew barber]

I’m currently working on a worksheet with over 2000 products. Try as I might I cannot work out the formula required (or if it’s even possible) to quickly complete the task in hand without going through line by line.

I already have the cost of the product in the table. Is there anyway of entering a formula in the price column that calculates price from a desired GM %?

eg.

C3 - Price = ???
D3 - Cost = £0.92
F3 -Margin = 31.85%

Thanks

 

[JoeMo]

Assuming Price = Cost/(1 - GM)

Excel Workbook
	C	D	E
2	Price	Cost	GM
3	1.35	0.92	31.85%
Sheet1

 

[matthew barber]

That’s gross margin % to be clear

 

[matthew barber]

Assuming Price = Cost/(1 - GM)
Sheet1

	C	D	E
Price	Cost	GM

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"></colgroup><tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]2[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]3[/TD]
[TD="align: right"]1.35[/TD]
[TD="align: right"]0.92[/TD]
[TD="align: right"]31.85%[/TD]

</tbody>

Spreadsheet Formulas

Cell Formula C3 =ROUND(D3/(1-E3),2) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

Thsnks for reply.. not sure what I’m doing wrong? Your price is correct above. But when I enter formula on excel that you have provided, price shows as 1.61 on my worksheet?

 

[matthew barber]

Sorry! Fixed!! Me being thick ..... again!

Thanks very much indeed!

 

[JoeMo]

Thsnks for reply.. not sure what I’m doing wrong? Your price is correct above. But when I enter formula on excel that you have provided, price shows as 1.61 on my worksheet?

Don't enter the formula. Instead, copy it from your browser and paste it to cell C3.

 

[JoeMo]

Sorry! Fixed!! Me being thick ..... again!

Thanks very much indeed!

You are welcome - thanks for the reply.