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