what is the usage of iif(len) function in sw electrical ? please help.
Do you have a screenshot of where you are intending to use it or what you're trying to reverse engineer? It's used in any formula that you want a condition acted upon, and in any column of a report that you want to check a condition for displaying certain info
Like Evan said, the IF statement has a conditional, what happens if it's true, and what happens if it's not.
The "len" command checks the "length" of a string - sometimes it's used to find out if there's actually any data there, like checking the length of a cable name for a wire to see if the wire is indeed associated with a cable core.
Retrieving data ...