IF Statement accepting only positive values
Hi guys,
I assume this is going to have to be done through data validation.
In column A, I have text in cells A1:A10, in column B, I want to put in a formula saying "If A1 contains 'test text', then only accept a positive number" and return an error if a negative number is attempted to be typed in. How do I do this?
Thanks,
Amin
|