HOW TO WORK OUT PERCENTAGE FROM COST PRICE AND PROFIT IN EXCEL

G

Guest

HOW TO WORK OUT PERCENTAGE FROM COST PRICE AND PROFIT IN EXCEL2000 eg:
cost price 6.5, selling price 30.00, percentage = ????? Can somebody please
help?

Malc
 
R

R.VENKATARAMAN

type A1 cost price. inB1 type sale price. In C1 type
=(B1-A1)/A1
format C1 as percentage(mine is Excel 2000)
 
K

Ken Wright

Depends what % you want to work out:-

Fee % expressed as % of Total Cost = (Sell Price - Cost price) / Cost price
Profit % expressed as Return on Sale (ROS) = (Sell Price - Cost price) / Sell
price

In say cell A1 put Cost price
In say cell A2 put Sell price

In cell A3 put either:-

=(A2-A1)/A1 or =(A2-A1)/A2

depending on which you want

That's one hell of a markup though, assuming you really meant Cost = 6.5 and not
Profit = 6.5
 
C

Celtic_Avenger

Can we get in on the deal that gives a mark up like that.....Wow!

Celtic_Avenge
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top