How to use excel cost margin calculator?

Asked By ayannahana 10 points N/A Posted on - 10/08/2012

I am trying to do my project in excel.

But I am not too familiar on excel features and tools.

Can someone help me on how I can calculate using the excel cost margin calculator?

• Status: Open
• Question Views: 1199
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Rain Bonnie

Go To Solution

Best Answer

Best Answer

Answered By Rain Bonnie 0 points N/A #142124

How to use excel cost margin calculator?

Margin is the difference between cost and sale price expressed as a Percentage of the Sale Value and about profit margin; it tells you the percentage of each sale that is profit.

 

Look at the formula…..

X=(100/(100-B7))*B6

Where B7 = Margin

B6 = Cost

X = Sell

For details go to

https://www.techwalla.com/articles/how-to-calculate-gross-profit-margin-using-excel

Thank You……..

About Rain Bonnie

Questions
1

Answers
59

Best Answers
11

• Vote Up 0 Vote Down

• Posted on - 10/10/2012
• Question Category: MS Excel

Answered By Kaile Smith 0 points N/A #142125

How to use excel cost margin calculator?

Hi Ayannahana!

Here are the steps on how to use excel cost margin.

You can find it here https://www.techwalla.com/articles/how-to-calculate-gross-profit-margin-using-excel. Just follow the step and apply it.

Read the procedure carefully and understand because they have 9 of it.

Thank You!

About Kaile Smith

Questions
1

Answers
100

Best Answers
25

• Vote Up 0 Vote Down

• Posted on - 10/12/2012
• Question Category: MS Excel