| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i calculate the difference between two numbers?
Hello,
I am having difficulty in finding the difference between two numbers, i have two cloumns which have for example the numbers C3=2 and D3=10, where the difference would be E3=8 and numbers C4=12 and D4=7 where the difference would be E4=5, how do i do this in excel without getting negative numbers such as C3-D3=-8? thank you for your help, Dougie |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i calculate the difference between two numbers?
On Nov 12, 4:52 am, dig wrote:
i have two cloumns which have for example the numbers C3=2 and D3=10, where the difference would be E3=8 and numbers C4=12 and D4=7 where the difference would be E4=5, how do i do this in excel without getting negative numbers such as C3-D3=-8? =abs(C3-D3) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i calculate the difference between two numbers?
The difference would be calculated as
=C3-D3 The absolute value of this is =ABS(C3-D3) -- HTH, Barb Reinhardt "dig" wrote: Hello, I am having difficulty in finding the difference between two numbers, i have two cloumns which have for example the numbers C3=2 and D3=10, where the difference would be E3=8 and numbers C4=12 and D4=7 where the difference would be E4=5, how do i do this in excel without getting negative numbers such as C3-D3=-8? thank you for your help, Dougie |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i calculate the difference between two numbers?
Thank you very much,
i am having difficulty, the cell displays as =ABS(C3-D3) how do i get it to display as a number? Thanks again "Barb Reinhardt" wrote: The difference would be calculated as =C3-D3 The absolute value of this is =ABS(C3-D3) -- HTH, Barb Reinhardt "dig" wrote: Hello, I am having difficulty in finding the difference between two numbers, i have two cloumns which have for example the numbers C3=2 and D3=10, where the difference would be E3=8 and numbers C4=12 and D4=7 where the difference would be E4=5, how do i do this in excel without getting negative numbers such as C3-D3=-8? thank you for your help, Dougie |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i calculate the difference between two numbers?
=ABS(C3-D3)
-- David Biddulph "dig" wrote in message ... Hello, I am having difficulty in finding the difference between two numbers, i have two cloumns which have for example the numbers C3=2 and D3=10, where the difference would be E3=8 and numbers C4=12 and D4=7 where the difference would be E4=5, how do i do this in excel without getting negative numbers such as C3-D3=-8? thank you for your help, Dougie |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i calculate the difference between two numbers?
=ABS(C3-D3)
best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "dig" wrote in message ... Hello, I am having difficulty in finding the difference between two numbers, i have two cloumns which have for example the numbers C3=2 and D3=10, where the difference would be E3=8 and numbers C4=12 and D4=7 where the difference would be E4=5, how do i do this in excel without getting negative numbers such as C3-D3=-8? thank you for your help, Dougie |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i calculate the difference between two numbers?
It sounds like you've got the cell formatted as text. Format the cell as
General or Number. You may need to go back to the formula and perhaps delete the = sign and re-enter. The other thing is to look at Tools/ Options/ View, and make sure that the "formulas" box is not checked. -- David Biddulph "dig" wrote in message ... Thank you very much, i am having difficulty, the cell displays as =ABS(C3-D3) how do i get it to display as a number? Thanks again "Barb Reinhardt" wrote: The difference would be calculated as =C3-D3 The absolute value of this is =ABS(C3-D3) -- HTH, Barb Reinhardt "dig" wrote: Hello, I am having difficulty in finding the difference between two numbers, i have two cloumns which have for example the numbers C3=2 and D3=10, where the difference would be E3=8 and numbers C4=12 and D4=7 where the difference would be E4=5, how do i do this in excel without getting negative numbers such as C3-D3=-8? thank you for your help, Dougie |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i calculate the difference between two numbers?
fantastic, that did it,
thank you so much for your help, much appreciated! Dougie "David Biddulph" wrote: It sounds like you've got the cell formatted as text. Format the cell as General or Number. You may need to go back to the formula and perhaps delete the = sign and re-enter. The other thing is to look at Tools/ Options/ View, and make sure that the "formulas" box is not checked. -- David Biddulph "dig" wrote in message ... Thank you very much, i am having difficulty, the cell displays as =ABS(C3-D3) how do i get it to display as a number? Thanks again "Barb Reinhardt" wrote: The difference would be calculated as =C3-D3 The absolute value of this is =ABS(C3-D3) -- HTH, Barb Reinhardt "dig" wrote: Hello, I am having difficulty in finding the difference between two numbers, i have two cloumns which have for example the numbers C3=2 and D3=10, where the difference would be E3=8 and numbers C4=12 and D4=7 where the difference would be E4=5, how do i do this in excel without getting negative numbers such as C3-D3=-8? thank you for your help, Dougie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate difference in Times | Excel Discussion (Misc queries) | |||
| Calculate the difference between two times | Excel Worksheet Functions | |||
| How do I calculate Time difference from PM to AM | Excel Discussion (Misc queries) | |||
| Calculate difference between two dates | Excel Worksheet Functions | |||
| How do you calculate the difference between two values within a p. | Excel Discussion (Misc queries) | |||
Linear Mode
