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.
Tag Archives: logic
Another plural technique for Excel
Out of LEFT field
Recently I found an interesting way to handle plurals in Jordan Goldmeier’s book on dashboards.
Validating Data Validation in Excel
Part One
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.
Excel Test For One of Two Conditions
A shorter alternative
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.
Towards a Simpler IF Function
New function in Excel 2016
Excel 2016 has introduced a new type of IF function to simplify handling multiple conditions. It is called IFS.
Handling DR and CR at the end of numbers in Excel
Sorting out debits and credits
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.
Checkerboard Format in Excel
How to get alternate shading in cells
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.
Towards a Shorter IF Function
Returning a range
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.
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?
Logic Calculations in Excel
Make the most of TRUE and FALSE
You don’t have to use an IF function to get the most out of logic calculations in Excel.