dimanche 1 novembre 2015

Excel - how to display "0", "+" or "-"?

I have tried googling for some time now, but I have not yet found the answer.

If I have an number (positive, negative, or equal to zero) in, let's say bracket A1, and I wish bracket A2 to show "+" if A1 is positive, "-" if A1 is negative or "0" if A1 is zero, does anyone know how to code this in excel?

Thank you.

Aucun commentaire:

Enregistrer un commentaire