The difference = Question
 

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 = Question
 

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

"Shmilu" wrote in message
...
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 = Question
 

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.)


New Delhi, India


"Shmilu" wrote:

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 = Question
 

Thank's that helped me alot.......

"Fred Smith" wrote:

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

"Shmilu" wrote in message
...
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!