mardi 31 janvier 2017

Excel - IF with 3 Outcomes

This question has been asked and answered, unfortunately when I adapt the answers to my situation all I get back is #Name. My need is a return out of "Positive", "Negative" or a no response, as follows

  • “Positive” any number >0
  • “Negative” any number <0 (negative number)
  • No return for a zero

I have tried =IF(A1=0;””;IF(A1<=0.01;”Negative”;“Positive”)) with using both semi-colons and commas.

Any help appreciated.

Aucun commentaire:

Enregistrer un commentaire