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