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!
|