vendredi 15 mai 2020

how to check if number begins with "+" in excel?

I need to check if number begins with "+" or "00" or "(" but when I try with this formule:

=IF(LEFT(E4="+",1),1,0), I got error#VALUE

enter image description here

Aucun commentaire:

Enregistrer un commentaire