UDFunctions and nested If-the-else statements

[JDB]

I read all of the posts regarding the nested If statements limited to 7
levels, so thought I would try a user defined function with more than 7
levels of If-then ElseIF statements. It seems to work to a nesting
level of 12 (have not tried higher). VLookups and Choose statements
were not applicable to this application because calculations were
involved in every step. Could not figure out how to use a CASE
statements either for this application.

Does using a UDF get around the nesting problem of 7 levels?

Thanks

JDB

 

[Niek Otten]

The 7-nested-ifs limit is for worksheet formulas, not for VBA