how do i calculate the difference between two numbers?

G

Guest

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
 
J

joeu2004

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?
Click to expand...

=abs(C3-D3)
 
G

Guest

The difference would be calculated as

=C3-D3

The absolute value of this is

=ABS(C3-D3)
 
G

Guest

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
 
D

David Biddulph

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Difference of the averages of two ranges 1
LOOPING STRUCTURE DESIRED 4 TWO RANGES 2
3 numbers in each cell aligned verticaly one number in each cell 1
Comparing Dates 4
#VALUE error add'g formulas 1
Fill down formula (but changing cell value by two) 1
formatting the difference between two cells 2

Top