Hello team,
This is my function; I put my function in a cell:
=IF(OR(LEFT(F2,3)=$V$2, LEFT(F2,3)=$V$3, LEFT(F2,3)=$V$4, LEFT(F2,33)=$V$5, LEFT(F2,3)=$V$6),"GG","ME")
It gives me error.
Unless I do Left function first and then on the next cell, I should use OR function on the result of Left function and then again on the next cell, I need to use If function on the result of OR function. What the problem is? I thinks: it says: #Value. All my values are number data type.
Regards,
GGGGGNNNNN
This is my function; I put my function in a cell:
=IF(OR(LEFT(F2,3)=$V$2, LEFT(F2,3)=$V$3, LEFT(F2,3)=$V$4, LEFT(F2,33)=$V$5, LEFT(F2,3)=$V$6),"GG","ME")
It gives me error.
Unless I do Left function first and then on the next cell, I should use OR function on the result of Left function and then again on the next cell, I need to use If function on the result of OR function. What the problem is? I thinks: it says: #Value. All my values are number data type.
Regards,
GGGGGNNNNN