How-To Geek on MSN

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

A structural nightmareThe IFS function: A redundancy nightmareThe solution: SWITCHThe SWITCH(TRUE) hack: The power-user ...
How-To Geek on MSN

I use these 3 Excel formulas to automate my boring chores

Life is hectic, and juggling dozens of apps for the "must-do" chores adds to the noise. Since I already work in Excel daily, I've expanded its use to automate three of my most boring tasks. These ...