Is there any software of excel for cost margin calculator

Asked By 10 points N/A Posted on -
qa-featured

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?

SHARE
Answered By 0 points N/A #134428

Is there any software of excel for cost margin calculator

qa-featured

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.

 

Related Questions