vendredi 30 septembre 2016

Excel If numbers end with '00'

Could you please help me write a IF formula so if a number end with '00' then output is A, else B. I wrote the following but it shows up as a #NAME?.

=IF((RIGHT(J3,2))="00",A,B)

Thanks in advance.

Aucun commentaire:

Enregistrer un commentaire