LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dig Dig is offline
external usenet poster
 
Posts: 17
Default how do i calculate the difference between two numbers?

Hello,
I am having difficulty in finding the difference between two numbers,
i have two cloumns which have for example the numbers C3=2 and D3=10, where
the difference would be E3=8 and numbers C4=12 and D4=7 where the difference
would be E4=5, how do i do this in excel without getting negative numbers
such as C3-D3=-8?
thank you for your help,
Dougie
 
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
Calculate difference in Times Darren Excel Discussion (Misc queries) 13 April 16th 07 12:02 PM
Calculate the difference between two times Buffgirl71 Excel Worksheet Functions 1 February 9th 06 10:10 PM
How do I calculate Time difference from PM to AM JAS123 Excel Discussion (Misc queries) 3 March 12th 05 12:37 PM
Calculate difference between two dates Trainer Excel Worksheet Functions 1 February 11th 05 02:04 PM
How do you calculate the difference between two values within a p. emlouise Excel Discussion (Misc queries) 2 December 10th 04 03:13 AM


All times are GMT +1. The time now is 12:35 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"