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!