Question: Excel Formula - Tipping $0.15
I have column A and B with numbers or blank. The numbers should be both positive or both negative or blank.
So e.g
5.00 5000 is acceptable
-5.00 5000 is NOT acceptable
-5.00 -5000 is acceptable
In Column C, I want a formula where if A and B is blank then put "-".
If A and B have both positive numbers put "acceptable" if both are negative put"acceptable"
where A is positive and B negative "REJECT" or where A is negative and B positive = "Reject"

[more]