Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default DIFFERENCE BETWEEN 2 CELLS IN EXCELL

i am trying to show the difference between one collum and another can;t find
formula

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 181
Default DIFFERENCE BETWEEN 2 CELLS IN EXCELL

You may need to give more information.
If you are trying to subtract the value in a1 from b1 then in c1 input
=b1-a1

--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"panamarab" wrote:

i am trying to show the difference between one collum and another can;t find
formula

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 833
Default DIFFERENCE BETWEEN 2 CELLS IN EXCELL

EXCEL 2007

1. In cell A1 type:-

10

2. In cell B1 type:-

5

3. In cell C1 type:-

=(A1-B1)

This returns the answer of 5.

Does the above answer your question?

If it does please hit Yes.

Thanks.



"panamarab" wrote:

i am trying to show the difference between one collum and another can;t find
formula

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
formatting the difference between two cells Hollywood003 Excel Discussion (Misc queries) 2 October 26th 09 03:45 PM
Trying to work out the difference in 2 cells. scary Excel Worksheet Functions 4 July 6th 08 01:55 PM
Getting Difference between two cells Jimmydageek Excel Worksheet Functions 3 February 19th 06 01:23 AM
Difference between Cells Jim Excel Worksheet Functions 2 October 27th 05 01:24 PM
Calculating the difference between cells SheriffCassidy Excel Worksheet Functions 3 February 15th 05 06:30 AM


All times are GMT +1. The time now is 10:23 AM.

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"