Excel IF fnction

[Phil Jackson]

We are trying to generate an extended IF function in Excel and need to know how many iterations can be put together - it appears to be 8 but does anyone know if this is the limit?

[gussery]

From Excel Help......
"Nesting level limits    A formula can contain up to seven levels of nested functions. 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."