ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Percentage problem (https://www.excelbanter.com/excel-discussion-misc-queries/20611-percentage-problem.html)

syssupspe

Percentage problem
 
Hi,
I am trying to find the formula for a percentage. Here are the numbers and
cells.
A1 - 1026
A2 - 1394
A3 - I need a formula that will tell me the percentage of growth that there
was from A1 to A2. I'm trying to determine how much the organization grew.
And these 2 numbers are the totals within a specific time frame.
Thanks

JulieD

Hi

if i remember my high school maths - the formula would be
=(A2-A1)/A1
formatted as a percentage

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"syssupspe" wrote in message
...
Hi,
I am trying to find the formula for a percentage. Here are the numbers and
cells.
A1 - 1026
A2 - 1394
A3 - I need a formula that will tell me the percentage of growth that
there
was from A1 to A2. I'm trying to determine how much the organization grew.
And these 2 numbers are the totals within a specific time frame.
Thanks





All times are GMT +1. The time now is 08:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com