I am trying to figure out how to mark a cell that either has a negative number, a positive number or no remaining
IF(OR(A1<0, A1>0), "negative", "positive") sees zero as positive.
How do I add a third condition to check, A1 can be 1, or -1, or 0?
This will be used to create a slice in a...