mardi 8 septembre 2020

If statement in excel don't return false value

I'm trying to understand why false statement is not working in this formula below.

=IF(FIND("(Pic";A1);LEFT(A1; FIND("(Pic";A1)-1);A1)

If in cell A1 find the string (Pic I just want to execute this part of code above:

LEFT(A1; FIND("(Pic";A1)-1)

and it's working. When the formula find (Pic it's executing properly.
But when the formula don't find (Pic I want to just take the whole string and that's why after the true statement, I just put ;A1)
But instead of return the value inside of A1, it's returning #VALUE!

Aucun commentaire:

Enregistrer un commentaire