| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Percentage between two numbers
Hi, i have this two situations:
2394 34 -98,58% 34 2394 6941,18% This is the formulas i used: =(B1-A1)/ABS(A1) =(B2-A2)/ABS(A2) I need a formula to calculate the percentage of differences between two numbers even if the first is bigger than the second or the other way around. This is how i need the final result to look: 2394 34 -98,58% 34 2394 +98,58% Can this be done? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| whole numbers plus a percentage | Excel Discussion (Misc queries) | |||
| whole numbers plus a percentage | Excel Discussion (Misc queries) | |||
| Percentage of a Column of numbers | Excel Discussion (Misc queries) | |||
| assign numbers a value, then get percentage | Excel Worksheet Functions | |||
| How do I add a percentage to a row of numbers | Excel Discussion (Misc queries) | |||
Threaded Mode
