Margin forumla question

Hi there,

Any help would be appreciated.

I have the margin and I have the sale price. How do I figure out the cost?

bump, can someone help me please

Hello? (echo....echo....echo)

Thank You

Originally Posted by NBVC

You mean?

=A1/(1+B1)

where A1 contains Sales price and B1 contain percent margin

What if there is a negative margin.....

Originally Posted by NBVC

If you have a negative margin....it means its costing you more than you are selling it for?

If so, same formula would apply.

If not so, please give example showing expected result.

If I'm selling it for $100 and my margin shows up as -100% that would mean my cost is $200. The formula I used gives me something else....

The attached formulas relate cost, price, discount, and margin.

Originally Posted by ratcat

Does this attachment help in anyway ???

Perfect! Thank You!

This formula attachment was very helpful. However, how would I alter either the formula or the result so that it would be represented as a whole number and not a fraction?

For example:
Cost = 1781
Price = 1947.49

Given the formula that was attached (1-c/p), my result of the above information would be 0.085489762. What if i wanted this number to be rounded up and represented as a whole number, like 9? Essentially, how can i move the decimal over two places to the right?