# Thread: Solved: Percentage formula question

1. ## Solved: Percentage formula question

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

2. A3:
=A2/A1 & " %"

Is it?  Reply With Quote

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

4. =B1-A1 & " %"  Reply With Quote

5. Sorry I had them on rows instead of in a colulmn....
try this:
=A2-A1 & " %"  Reply With Quote

6. =(A2-A1)/A1%  Reply With Quote

7. =ABS(A1-A2)/A1

and format as a percentage  Reply With Quote

8. Hmmm.... one uses A1-A2 and the other A2-A1.  Reply With Quote

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

10. Originally Posted by Aussiebear
Hmmm.... one uses A1-A2 and the other A2-A1.
Hmmm ... with ABS it is irrelevant.  Reply With Quote

11. 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?  Reply With Quote

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•