A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

WORKING OUT PERCENTAGES



 
 
Thread Tools Display Modes
  #1  
Old March 4th 06, 07:25 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: n/a
Default WORKING OUT PERCENTAGES

i'm trying to calculate increases in income, in percentage form. The
information given by microsoft office has not helped
Ads
  #2  
Old March 4th 06, 08:41 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: n/a
Default WORKING OUT PERCENTAGES

=B1/A1-1

where A1 is the start income, B1 is the end income, and format the cell as
percentage.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Suzie - Out Of Africa!" <Suzie - Out Of >
wrote in message ...
> i'm trying to calculate increases in income, in percentage form. The
> information given by microsoft office has not helped



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
amount of working days per month Nigel Excel Discussion (Misc queries) 2 November 29th 05 10:41 AM
Calculation with Working day of the year Box666 Excel Discussion (Misc queries) 4 November 10th 05 06:33 PM
Working days left in the month compared to previous months qwopzxnm Excel Worksheet Functions 8 October 24th 05 08:00 PM
Working time and days Nortos Excel Discussion (Misc queries) 1 May 6th 05 03:47 PM
Sumproduct function not working Scott Summerlin Excel Worksheet Functions 12 December 4th 04 05:15 AM


All times are GMT +1. The time now is 04:05 AM.


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