Let's look at how to properly create a complex nested IF statement using multiple IFs, and when to recognize that it's time to use another tool in your Excel arsenal.

Nest (include) other functions inside the IF function in a formula to mimic an If Then statement. You can nest up to 64 functions in another function.

Use the IF function along with AND, OR and NOT to perform multiple evaluations if conditions are True or False. IF (AND ()) - IF (AND (logical1, [logical2], ...), value_if_true, [value_if_false]))

Nest (include) other functions inside the IF function in a formula to mimic an If Then statement. You can nest up to 64 functions in another function.

For example, the AVERAGE function and the SUM function are both second-level functions if they are used as arguments of the IF function. A function nested within the nested AVERAGE …

You can also nest multiple IF functions together in order to perform multiple comparisons. =IF (C2>B2,”Over Budget”,”Within Budget”) In the above example, the IF function in D2 is saying …

The OR function requires a set of arguments (pieces of data) that it can test to see if they're true or false. In this formula, the first argument is the AND function and the DATE function nested …

The IFS function checks whether one or more conditions are met, and returns a value that corresponds to the first TRUE condition. IFS can take the place of multiple nested IF …

Here's an example of a well-constructed formula that nests an IF function inside another IF function to calculate deductions based on income level. =IF (E2<31500,E2*15%,IF …

In Access, if you need to calculate or display a value based on a condition, use the IIf function. The IIf (Immediate If) function is similar to the If function in Excel.