They could use the following formula: Nested IF and AND/OR functions are quite powerful and unlock a new world of analysis and data reporting. You can use them for conditional formatting in Excel ...

Take this complex nested IF statement ... and readable compared to a basic SWITCH statement. As with any function in Excel, you can combine these functions. You can place an IF statement within ...