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