Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Nested IIF question Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
fast70gs
Posted : Wednesday, April 4, 2018 1:12:08 PM
Registered User
Joined: 5/30/2014
Posts: 53

How many times can the IIF statement be nested? 

StockGuy
Posted : Wednesday, April 4, 2018 1:37:41 PM

Administration

Joined: 9/30/2004
Posts: 9,187

Good question. I don't think there is a defined limit, but depending on how lengthy/complicated the overall formula is it might get rejected by our servers.

fast70gs
Posted : Wednesday, April 4, 2018 1:54:20 PM
Registered User
Joined: 5/30/2014
Posts: 53

What I'm working on will require it to be nested 40 times.  It already works at 20. 

StockGuy
Posted : Wednesday, April 4, 2018 1:54:58 PM

Administration

Joined: 9/30/2004
Posts: 9,187

Only way to find out is to try it. 

fast70gs
Posted : Wednesday, April 4, 2018 3:08:15 PM
Registered User
Joined: 5/30/2014
Posts: 53

(how dd I post a blank reply?)

Will do!

Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.