How-To Geek on MSN

Stop writing nested IFs and IFS formulas in Excel: Use SWITCH instead

Messy Excel formulas are more than just an eyesore—they're harder to maintain. Every repeated cell reference and tangled parenthesis makes your work difficult to audit, edit, and share. That's why you ...
Ars Technica

Huge switch statements.

So I'm in a code review and this one person wrote a 1000+ line switch statement with nested if / else blocks and nested switch statements.<BR><BR>Am I wrong in thinking this is very bad? The McCabe ...