PC Review


Reply
Thread Tools Rating: Thread Rating: 1 votes, 5.00 average.

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
 
Reply With Quote
 
 
 
 
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



 
Reply With Quote
 
 
 
 
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


 
Reply With Quote
 
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

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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 Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a total cost chart where a component cost is a step cost gvm Microsoft Excel Charting 0 28th Apr 2010 02:10 PM
Calculate the percentage from the cost and recommended sell price =?Utf-8?B?Sm9obg==?= Microsoft Excel New Users 5 26th Feb 2006 04:07 AM
Confusion on adding percentage of cost to that cost. strommsarnac@gmail.com Microsoft Excel Worksheet Functions 11 13th Jul 2005 11:45 PM
Auto Calculating Net Profit and YTD Profit - How? lanna Microsoft Excel Discussion 4 27th Mar 2004 02:20 AM
Auto Calculating Net Profit and YTD Profit - How? lanna Microsoft Excel Programming 4 27th Mar 2004 02:20 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:32 PM.