SOLUTION: OK I didn't do well in Algebra and maybe someone can help... I feel like a retard.
I need a formula for MS Excel that can calculate a percentage based on cost vs sale.
Exampl
Question 151285: OK I didn't do well in Algebra and maybe someone can help... I feel like a retard.
I need a formula for MS Excel that can calculate a percentage based on cost vs sale.
Example:
Cost = $1478.00 --- Sale = $1950.00 --- Profit = $472.00
I need an formula that I can have MS Excel to compute what the % of profit was made.
Thanks in advance for your help! Answer by scott8148(6628) (Show Source):
You can put this solution on YOUR website! the profit is a percentage of the cost __ if you buy something for a nickel and sell it for a dime, you make 100% profit
% profit=[(sale - cost)/(cost)]*100
in your example __ %p=[(1950-1478)/1478]*100 __ %p=32 (approx)
