Give a 3 year old a hammer and they think everything is a nail.
The same thing happens to Excel users. They get to a certain skill level, pick up the IF statement, and realize that this can solve so many problems they’ve had in the past by nesting IFs.
The problem is that this method gets cumbersome, and troubleshooting it can be difficult.
Office for Mere Mortals has offered some alternatives including Lookup Tables and VBA, readers responded with tips for using MATCH, AND, OR, and especially CHOOSE.
