ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Finding difference between two cells (https://www.excelbanter.com/excel-programming/297436-finding-difference-between-two-cells.html)

somu Arunachalam

Finding difference between two cells
 
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

Finding difference between two cells
 
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

"somu Arunachalam" wrote in message
...
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




Paul Robinson

Finding difference between two cells
 
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

"somu Arunachalam" wrote in message ...
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



All times are GMT +1. The time now is 07:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com