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 ...
How-To Geek on MSN

You need to know what the double unary operator (--) does in Excel

It's cleaner and less cluttered: The double-unary operator is the most concise way to apply a mathematical coercion operation to an array. For example, if you have a complex nested array formula, two ...