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

Calculation of Gross Margin in a pivot table 1
Mark up and Margin 3
gross profit 2
subtotal by a range 4
price list changes using conditional functions? 3
help me :( 2
how do i set up a profit margin formula 4
Calculate Margins 3

Top