Hi there,
I am trying to put a LEN() formula inside of the IF() but this error appears:
“LEN function is used incorrectly”
Formula looks like this:
IF(
AND(
LEN([Z])=7;
IN([Z],xyz[Z]));
[A]<>“B”;
[A]=“A”
)
Am I doing sth wrong? It htis article:
the LEN() formula looks the same. Cannot find the solution. Please help me guys.
Mat
User | Count |
---|---|
35 | |
31 | |
30 | |
19 | |
17 |