Thread Tools Rating:

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

=?Utf-8?B?TWFsYw==?=
Guest
Posts: n/a

 30th Oct 2004
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.VENKATARAMAN
Guest
Posts: n/a

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

Malc <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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

Ken Wright
Guest
Posts: n/a

 30th Oct 2004
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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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

Celtic_Avenger
Guest
Posts: n/a

 30th Oct 2004

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

Celtic_Avenge

--
Celtic_Avenge
-----------------------------------------------------------------------
Celtic_Avenger's Profile: http://www.excelforum.com/member.php...fo&userid=1410
View this thread: http://www.excelforum.com/showthread.php?threadid=27384

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post gvm Microsoft Excel Charting 0 28th Apr 2010 02:10 PM =?Utf-8?B?Sm9obg==?= Microsoft Excel New Users 5 26th Feb 2006 04:07 AM strommsarnac@gmail.com Microsoft Excel Worksheet Functions 11 13th Jul 2005 11:45 PM lanna Microsoft Excel Discussion 4 27th Mar 2004 02:20 AM lanna Microsoft Excel Programming 4 27th Mar 2004 02:20 AM

Features

Advertising

Newsgroups

All times are GMT +1. The time now is 08:54 PM.