The difference = Question

  • Thread starter Thread starter Shmilu
  • Start date Start date
S

Shmilu

Im still kinda new at the excel and setting up formulas but I was needing a
little help if I could with this.
I need to find the difference between 2 numbers 7.26698-7.06068 which the
answer will show % of difference in another column for charting?
How will the formula look steup for this?
Thanks!
 
The difference between two numbers is done with subtraction, as in:
=a2-a1

If you want the percent difference, subtract the two numbers (to get the
difference), and divide by the original number (to get percent), as in:
=(a2-a1)/a1
Format the cell as a percentage.

Regards,
Fred
 
Hi, Try following

a1 = 7.26698
a2 = 7.06068
b2 =ABS(A1-A2)/A1

or = abs(7.26698-7.06068)/7.26698

In cell b2, you will get the difference and that too in percentage format.

Thanks
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India
 
Thank's that helped me alot.......

Fred Smith said:
The difference between two numbers is done with subtraction, as in:
=a2-a1

If you want the percent difference, subtract the two numbers (to get the
difference), and divide by the original number (to get percent), as in:
=(a2-a1)/a1
Format the cell as a percentage.

Regards,
Fred
Click to expand...
 
Back
Top