Finding difference between two cells

[somu Arunachalam]

my doubt is too basic I was using excel function in the
function I did not get a function two find the difference
between two cells can any one suggest me how to find the
difference between two cells

 

[Bernie Deitrick]

somu,

If by "difference" you mean the mathematical variety, then the difference
between A1 and A2 is simply

=A1-A2

or

=ABS(A1-A2)

HTH,
Bernie
MS Excel MVP

 

[Paul Robinson]

Hi
In A3 type
= A2 - A1

to get the difference between the value in A2 and that in A1. Blank
cells will be taken as 0 value. You will get an error message if your
cells contain text.

regards
Paul