if/then statement limits

[mktg@wfi]

is there a limit to the number of iif statements i can have in one field?

 

[Sharkbyte]

255 characters??? If nothing else, I would think that one, but you never
know till you try. =)

Sharkbyte

 

[Mauricio Silva]

If you need so many iif statements, you may consider use some other function
like choose or switch.

What are you trying to do ?

Mauricio Silva

 

[Duane Hookom]

I generally find that more than a couple IIf()s suggests using a lookup
table of ranges or related information. You can maintain data much easier
than complex IIf()s.

However you have provided very little information regarding your situation.