The Magical N Function in Excel
One reason I like the N function is because it is Excel’s shortest function name. But it has quite a few useful features as well.
(more…)Another plural technique for Excel
Recently I found an interesting way to handle plurals in Jordan Goldmeier’s book on dashboards. (more…)
Validating Data Validation in Excel
The most common type of Data Validation in Excel is a drop down list. In the example below I allow the user to select a year, then a month (using a drop down) and then enter a valid day in the month. (more…)
Excel Test For One of Two Conditions
In Excel it is quite common to test a cell for either a zero or a blank. If either of these two entries are found then you do a particular calculation. There is an easy way to handle this. (more…)
Towards a Simpler IF Function
Excel 2016 has introduced a new type of IF function to simplify handling multiple conditions. It is called IFS. (more…)
Handling DR and CR at the end of numbers in Excel
Some systems add DR and CR to the end of numbers when they export into Excel. This renders the values useless for normal calculations. You can use data cleansing techniques to remove the characters using formulas or Power Query. There is one function however that can perform calculations on these types of entries. (more…)
Checkerboard Format in Excel
I was looking at a calendar and noticed it used alternately shaded cells, like a checkerboard, for all the dates and thought Excel could do that. (more…)
Towards a Shorter IF Function
Most people think that the IF function has to return a result. This leads to doing whole calculations in the true and false sections of the IF function. There is a way to create shorter functions. (more…)
Identifying if an entry is one of a group
You have a number of options that require the same treatment. What is the easiest way to identify if an entry is one of a list? (more…)