Custom Number Formats (Multiply & Divide by any Power of 10)
In the past here at Chandoo.org and at many many other sites, people have asked the question
“How can I display a number multiplied or divided by 10, 100, 1000, 1000000 etc, but still have the cell maintain the original number for use in subsequent calculations”.
Typically the answer has been limited to “It can’t be done” or “it can only be done in multiples of 1000”.
This post will show you how you can display numbers whilst Dividing or Multiplying the cells value by any Power of 10 !
Excel Links – Live from Bangkok Edition
It has been a while since we had an Excel Links feature. So here we go again. But before jumping in to all the Excel goodness, let me share a few tidbits about our Bangkok adventure.
Cleaning Up Imported Data – A Recent Case Study
Houston, We’ve Had a Problem!
In the initial emails requesting a solution to yesterday’s Formula Forensics, Chandoo’s solution, although Technically correct, Didn’t work ?
This post looks at the problem and what was wrong with the data causing the error.
Formula Forensics No. 008 – Elkhan’s MaxIf
Today in Formula Forensics we look at how to Calculate the Maximum value from a list subject to other fields meeting certain criteria:
Excel’s Auditing Functions [Spreadsheet Risk Management – Part 3 of 4]
This series of articles will give you an overview of how to manage spreadsheet risk. These articles are written by Myles Arnott from Excel Audit Part 1: An Introduction to managing spreadsheet risk Part 2: How companies can manage their spreadsheet risk Part 3: Excel’s auditing functions Part 4: Using external software packages to manage […]
Formula Forensics. 009 – Pradhishnair’s Chainage Problem
A common Forum Post question and one that Chandoo has written about a few times is, Does my data overlap with another range?
This week Formula Forensics examines Pradhishnair’s Overlapping Chaninage Problem where he wants to know if two values overlap with a range of other values
Six Quick Updates
Hello my friend,
I have a few quick updates to start the week. Just read on to keep up.
Excel VBA section of Chandoo.org
During last few weeks, I have spent several hours organizing all the VBA material on Chandoo.org. I am happy to announce our brand to Excel VBA area of the site.
This section has Excel VBA overview, examples, videos, tips, books, references & more. Check it out.
Read on for the remaining 5 updates…