So I'm calculating gross margin with no issues...
(Sell - Cost)/Sell
Here's the question... what if the sell is negative and causes the entire Gross Profit calculation (Sell - Cost) to be negative? Then I get a false positive Gross Margin. Example:
Sell = -5
Cost = 3
(-5 - 3)/-5
-8/-5 = 1.6
Is there a correct way to do this? Or do I just use a statement that makes the Gross Margin % zero if the Gross Profit is negative?
Bookmarks