G Guest Jun 7, 2005 #2 255 characters??? If nothing else, I would think that one, but you never know till you try. =) Sharkbyte
255 characters??? If nothing else, I would think that one, but you never know till you try. =) Sharkbyte
G Guest Jun 7, 2005 #3 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
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
D Duane Hookom Jun 7, 2005 #4 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.
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.
