>>Hi John
>>
>>I'm neither an economist nor a mathematician. Exposure to business and accounting systems may be enough. Assuming the margin is the difference between the cost and the sales as a percentage of the sales price, doesn't this work?
>>
>>abs(tnPrice-tnCost)/tnPrice*100
>>
>>HTH
>
>I've already tried that. What is happening is:
>
>Assuming 2.00 cost and 8.00 price, the formula calculates the margin at 75%.
>Assuming 2.00 price and 8.00 cost, the formula says its -300%.
>
>Shouldn't that be -75% in the second or am I not understanding the process or the math?
Negative margins are valid, aren't they? How else can you calculate whether you are going in the whole or not.
That said, how about:
round((tnPrice-tnCost)/tnCost*100,1)
Price Cost Result
8.00 2.00 300%
2.00 8.00 -75%
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao