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 and nest multiple AND/OR functions for ...