Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 47
Default What is the percentage

Hi I have a value of (A) 642 and a value of (B) 385.20. The difference is
256.80 what formula would I use to find the percentage of value 256.80

Thank you
--
smile
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 905
Default What is the percentage

"israel" wrote:
I have a value of (A) 642 and a value of (B) 385.20.
The difference is 256.80 what formula would I use
to find the percentage of value 256.80


If you want the percentage increase from 385.20 to 642, then:

=A1/B1 - 1

formatted as Percentage. You can also write =(A1-B1)/B1.

If you want the percentage decrease from 642 to 385.20, then:

=B1/A1 - 1

You can also write =(B1-A1)/A1.

If you want something else, it would help if you gave a numerical example as
you worked it out on paper; that is, "show your work".
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Percentage S New Users to Excel 2 March 11th 09 08:27 AM
Percentage of tmaxwell Excel Worksheet Functions 2 May 17th 07 07:26 PM
Percentage help with excel New Users to Excel 1 February 12th 07 10:41 PM
Calculating a percentage with the end percentage in mind Shadowshady Excel Discussion (Misc queries) 2 June 17th 06 09:41 AM
Bar Chart depicting the "percentage of another percentage(less than 100)" TEAM Charts and Charting in Excel 1 October 28th 05 05:06 AM


All times are GMT +1. The time now is 02:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"