ExcelBanter - gross margin

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - gross margin (https://www.excelbanter.com/excel-worksheet-functions/205773-gross-margin.html)

unojim

gross margin

i am trying to establish a fromule for product cost for a customer by going
backwards from their margin expectation and retail price

Marcelo

gross margin

Hi,

try

=(price*(1-margin))

assuming the price is 1,200 the expected margin is 15%

=(1200*(1-15%)) = 1,020

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo

"unojim" escreveu:

i am trying to establish a fromule for product cost for a customer by going
backwards from their margin expectation and retail price

All times are GMT +1. The time now is 04:01 AM.