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.