ExcelBanter - UDFunctions and nested If-the-else statements

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - UDFunctions and nested If-the-else statements (https://www.excelbanter.com/excel-worksheet-functions/67344-udfunctions-nested-if-else-statements.html)

UDFunctions and nested If-the-else statements

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

UDFunctions and nested If-the-else statements

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

--
Kind regards,

Niek Otten

"JDB" wrote in message
oups.com...
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