View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default 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!