| 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? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formula for difference between numbers without + or-
=ABS(A1-B1)
-- Kind regards, Niek Otten Microsoft MVP - Excel "ParvenuJohn" wrote in message ... | 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? | |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formula for difference between numbers without + or-
On Tue, 23 Oct 2007 03:56:00 -0700, ParvenuJohn
wrote: 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? =abs(a1-a2) --ron |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formula for difference between numbers without + or-
=ABS(A3-B3)
Regards, Soundar. "ParvenuJohn" wrote: 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? |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formula for difference between numbers without + or-
Thanks everyone - I think I now have the basic formula, which is "ABS" I will
try it. Thanks again ParvenuJohn "Soundar" wrote: =ABS(A3-B3) Regards, Soundar. "ParvenuJohn" wrote: 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? |
| Reply |
| 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 | |||
Hybrid Mode
