As a worksheet function, the IF function can be entered as part of a formula in a cell of a worksheet. It is possible to nest multiple IF functions within one Excel formula in Excel 4 Outcomes. You can nest up to 7 IF functions to create a complex IF THEN ELSE statement.