Recently I found an interesting way to handle plurals in Jordan Goldmeier’s book on dashboards.
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.
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.
Excel 2016 has introduced a new type of IF function to simplify handling multiple conditions. It is called IFS.
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.
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.
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.
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?
You don’t have to use an IF function to get the most out of logic calculations in Excel.