Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,441
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 208
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Finding the difference Renegade Excel Discussion (Misc queries) 1 April 6th 09 09:13 PM
finding date difference Totti Excel Discussion (Misc queries) 4 October 15th 08 09:35 PM
Finding the difference Heather Excel Discussion (Misc queries) 4 August 1st 08 02:50 PM
Finding the difference between two numbers Christian J. Sweatt Excel Worksheet Functions 3 September 15th 07 04:10 AM
Finding Time difference John Harris Excel Worksheet Functions 2 May 13th 05 11:32 PM


All times are GMT +1. The time now is 12:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"