# The Magical N Function in Excel

### Who you calling short?

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.

# 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.