Friday, March 04, 2005
How do you make Excel show the difference between two selected cells
I was asked this very interesting question a couple of days ago.
I have to admit I am stumped. I have also wondered this for many years and I have never found a way to do it. Of course you can subtract one cell from another but often I will have two cells on a spreadsheet with values in them that I am trying to reconcile. If they do not balance then I want to know how much I am out, or the difference between the two cells values.
If one is a negative and one a positive number then selecting them and using the sum in the status bar will give you a result.
The task - determine the difference between two positive numbers in selected cells.
Do any of you readers know how to do this? UDF's (User Defined Functions) are an acceptable solution.
The Excel Guru's Free Tips and Hints.
Welcome
Welcome to the Excel Tips blog. Free Microsoft Excel Tips and Hints designed to increase your productivity.
Advertisement
Subscribe Me
Previous Posts
- Autumn in Excel
- Calendar Picker Addin for Excel
- Another Excel Site
- AND and OR Functions in Excel
- Free XML Developers Book
- Freezing Panes In Excel
- Edit Directly in Cell in Excel
- Using text in Excel
- Using Expandable Range names in Excel
- Formula Auditing in Excel
My Blogs and Websites
- Spy Journal Home
- Spy Journal Archives
Personal Blog- Excel Tips Blog
- Blog Tips Blog
- Tech Tips Blog
- Urban Space Novel
- Photo Archive
- Parklife Results
- Parklife Soccer Club Website
- KROSTech LAN Parties
- Jethro Management
- Jethro Consultants
- Oz Bush Poet
Excel Links
- ---RSS Feeds---
- Unofficial Microsoft Office Stuff
- KC on Exchange and Outlook
- Office Zealot
- Automate Excel
- Colo's Excel Junk room
- Daily Dose Of Excel
- The Planning Deskbook
- Excel Pragma
- Andrew's Excel Tips
- ---No RSS Feed---
- Excel Tip
- Mailbarrow
- Experts Exchange
- AJP Excel Information
- Beyond Technology
- Contextures
- ExcelTip
- Mr Excel
- Pearson Software Consulting
- Peltier Technical Services
- John Walkenbach - J-Walk
- Vangelder (wont work in Firefox)
- VBA Express
- xlDynamic
- The Excel Nexus
- Code Net
- Better Solutions
- Excel Business Tools
- Data Pig Technologies
- VBA Express
Other Links
Copyright Notice. All documents and text contained in this web site www.spyjournal.biz and sub pages is copyright material of Jethro Management (c) 2004 unless noted as being copyright material of someone else. No public reproduction of the content on this site in any form is permitted without express written permission.
Unless otherwise expressly stated, all original material of whatever nature created by Tim Miller and included in this weblog and any related pages, including the weblog's archives, is licensed under a Creative Commons License.