Writing a nested
IF statement is widely considered a rite of passage for beginning Excel users who are looking to become more advanced.
The overall concept of writing a nested
IF is actually fairly simple; it's just that process of doing so is highly prone to making mistakes, which can make learning it somewhat difficult.
Having a strong level of comfort around logical structuring is critically important to Excel proficiency. Therefore, if you want to get good at Excel, you should learn how to write nested
IF statements regardless of which approach becomes your preference.