Finding difference between two cells

  • Thread starter somu Arunachalam
  • Start date
S

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
 
B

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
 
P

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
 
Top