Two-Level Nested Function in Excel

Two-Level Nested Function

Functions are formulas that perform calculations in a spreadsheet. Functions can be combined where one of the values can be a function itself. This means that there is a function within a function. Instead of having a number as part of a calculation, you can have another function. This can be used when more than one criteria needs to be met within a calculation. The IF function can be used in this way. For example:

=IF(OR(E2>40,F2<6),20,10)

In the table below, this is calculating IF the number of sales is below 40 OR the number of days absent is less than 6, the employee bonus will be €20. If not, the bonus will be €10.

1. Enter the following information:

2. We want to award a €20 bonus for staff who had over 40 sales or less than 6 days’ absence, if not, award a €10 bonus

3. In cell G2, enter =IF(OR(E2>40,F2<6),20,10)

4. Use the fill handle to copy the formula

This function can be used in budgets, tables of data as well as performing financial calculations.

For more information about Advanced Excel features, click on the image below: