UDFunctions and nested If-the-else statements

J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top