There’s a cleaner, saner way to build formulas with multiple conditions.

Source: If you’re still nesting IFs in Excel, you’re doing it the hard way