if less than

[JosieJosie02]

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 pivot, to show the values of Negative Amounts, Positive Amounts or No Remaining Amount.

 

[Peter_SSs]

I agree that the OR() should not be there. Or rather it is wasted there.
If interested, here is another shorter way

23 11 30.xlsm
	A	B
1	5	Positive Amounts
2	0	No Remaining Amounts
3	-2	Negative Amounts
Pos Neg Zero

Cell Formulas
Range	Formula
B1:B3	B1	=CHOOSE(SIGN(A1)+2,"Negative","No Remaining","Positive")&" Amounts"