Is there any software of excel for cost margin calculator

Asked By Asheley Madison 10 points N/A Posted on - 09/03/2012

I am having some problem to calculate cost margin in excel. So I want to know if there is any excel cost margin calculator software to ease my work. Can anyone provide any help?

• Status: Open
• Question Views: 859
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Niley Samilene 0 points N/A #134428

Is there any software of excel for cost margin calculator

Hi Asheley Madison,

I have found two margin calculator for excel spreadsheet.

The website addresses are provided here:

http://margin-calculator-calcul-de-marge.software.informer.com/

https://support.office.com/en-us/article/Excel-video-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb?wt.mc_id=otc_home&ui=en-US&rs=en-US&ad=US

You can also use the Vlookup formula to find out cost margin.

Another formula can be used. The “IF” functions for calculating cost margin.

If the list cost price remains in the ‘A’ line, the following function may work.

=IF(A9<20.01,1.44,IF(A9<100,1.35,IF(A9<200,1.26,1.2)))

The formula will return 1.44 if the cost is less than $20.01. If the cost is more than $20 then it will evaluate the next test and return the 1.35 if the cost is <$100 (example: > $20.00 and <$100.00) it will continue to evaluate successive if statements. If none of the tests return a TRUE then the formula will revert the last number 1.2.

 

About Niley Samilene

Questions
2

Answers
92

Best Answers
17

• Vote Up 0 Vote Down

• Posted on - 09/03/2012
• Question Category: MS Excel