Thread: gross margin
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default 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