gross margin

U

unojim

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

Marcelo

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Publisher office 365 0
Insert name and adress from a list in a word document 1
Word 2013 Set Different Margins for Different Pages 1
Outlook 365 Signatures 0
Mail Merge Directory Conditional Page Break 0
Book formatting: need to alternate page number on left and right margin for only first page of each 2
price list changes using conditional functions? 3
excel formula for markup and profit margin 3

Top