| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formula for difference between numbers without + or-
I'm fairly new to Excel. I want to create a formula to show the difference
between 2 numbers, in different columns, but without positive or negative values. eg. the difference between 1 and 7 is 6. The difference between 7 and 1 is 6. I do NOT want to see the result as -6 and 6. Imagine the cells are A3 and B3, for these numbers. How do I do this please? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| difference between 2 numbers | Excel Discussion (Misc queries) | |||
| Finding the difference between two numbers | Excel Worksheet Functions | |||
| Show % Difference between two numbers | Excel Discussion (Misc queries) | |||
| Find all possible Difference between two sets of numbers | Excel Worksheet Functions | |||
| calculating the difference between 2 numbers | Excel Worksheet Functions | |||
Threaded Mode
