View Full Version : Solved: Percentage formula question

austenr

11-10-2006, 09:14 AM

This is real easy but i can't remember how to do it. Say you have the number 695769 in A1 and the number 623909 in A2. What is the correct formula to use if you want to determine how much of an increase or decrease the second number is from the first percentage wise? Thanks

Erdin? E. Ka

11-10-2006, 09:24 AM

A3:

=A2/A1 & " %"

Is it?

austenr

11-10-2006, 09:39 AM

Well, that does not look right. I get a percentage of 1.115% difference between the two numbers. Should it not be higher?

lucas

11-10-2006, 09:46 AM

=B1-A1 & " %"

lucas

11-10-2006, 09:49 AM

Sorry I had them on rows instead of in a colulmn....

try this:

=A2-A1 & " %"

mdmackillop

11-10-2006, 10:01 AM

=(A2-A1)/A1%

Bob Phillips

11-10-2006, 11:08 AM

=ABS(A1-A2)/A1

and format as a percentage

Aussiebear

11-10-2006, 12:21 PM

Hmmm.... one uses A1-A2 and the other A2-A1.

austenr

11-10-2006, 12:25 PM

Thanks everyone. Bob, I used your formula. I thought I remembered something about ABS in it but could not remember. Solved.

Bob Phillips

11-10-2006, 01:37 PM

Hmmm.... one uses A1-A2 and the other A2-A1.

Hmmm ... with ABS it is irrelevant.

mdmackillop

11-10-2006, 05:19 PM

Hi Austen,

If A1 = 4 and A2= 6 what do you want to see in the result cell 0.5 or 50 or 50% or something else?

Powered by vBulletin® Version 4.2.5 Copyright © 2020 vBulletin Solutions Inc. All rights reserved.