Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding the difference | Excel Discussion (Misc queries) | |||
finding date difference | Excel Discussion (Misc queries) | |||
Finding the difference | Excel Discussion (Misc queries) | |||
Finding the difference between two numbers | Excel Worksheet Functions | |||
Finding Time difference | Excel Worksheet Functions |