7 hours ago
1.
Is the new _IIF limited to only numerics ? Or can I play with strings too ?
2. Can this statement be on one line: p=_iff(p=instr(thing$,"\"): p <= 10, p, p=0)
re: position of "\" must be less than 11 else make it zero
Question two in my mind very iffy. If question #1 is true.
Don't need an code answer for question 2. I could do that in my sleep.
Just thought sub-coding might be possible in a coded line.
Is the new _IIF limited to only numerics ? Or can I play with strings too ?
2. Can this statement be on one line: p=_iff(p=instr(thing$,"\"): p <= 10, p, p=0)
re: position of "\" must be less than 11 else make it zero
Question two in my mind very iffy. If question #1 is true.
Don't need an code answer for question 2. I could do that in my sleep.
Just thought sub-coding might be possible in a coded line.