Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JDB
 
Posts: n/a
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten
 
Posts: n/a
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"