Nested Formula

Hi Adam,

A formula can only contain up to 7 levels of nested functions which may include various function types.

When Function B is used as an argument in Function A, Function B is a second-level function. For instance, the AVERAGE function and the SUM function are both second-level functions because they are arguments of the IF function. A function nested within the AVERAGE function would be a third-level function, and so on.

I hope that this helps.

Rodney