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

Discussion in 'Microsoft Excel Programming' started by Guest, Oct 30, 2004.

1. ### GuestGuest

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

Guest, Oct 30, 2004

2. ### R.VENKATARAMANGuest

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

Malc <> wrote in message
news:...
> HOW TO WORK OUT PERCENTAGE FROM COST PRICE AND PROFIT IN EXCEL2000 eg:
> cost price 6.5, selling price 30.00, percentage = ????? Can somebody

> help?
>
> Malc

R.VENKATARAMAN, Oct 30, 2004

3. ### Ken WrightGuest

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

"Malc" <> wrote in message
news:...
> 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

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.784 / Virus Database: 530 - Release Date: 27/10/2004

Ken Wright, Oct 30, 2004
4. ### Celtic_AvengerGuest

Celtic_Avenger, Oct 30, 2004