Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtracting positive amts from negative and positive from positive | Excel Worksheet Functions | |||
Protected sheet accepting values from List | Excel Discussion (Misc queries) | |||
Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
Pivot table page filter not accepting multiple values. Workaround? | Excel Worksheet Functions | |||
... Count, <<< Positive Values minus Negative Values >>> ... | Excel Worksheet Functions |