| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table "Difference From" Question | Excel Discussion (Misc queries) | |||
| Time difference calculation question | Excel Worksheet Functions | |||
| subtract the time difference from another time difference | Excel Discussion (Misc queries) | |||
| charting a difference of 2 columns' w/o adding a difference column | Charts and Charting in Excel | |||
| Simple question: Difference between two dates? | Excel Discussion (Misc queries) | |||
Linear Mode
