Aussiebear
03-14-2010, 12:16 AM
How can I validate the following:
If A1 = Buy, then B1 value (whole number) when entered by the user needs to be stored as a negative number,and if A1 = Sell then B1 is stored as a positive number. I've looked at Data Validation Custom which allows a formula but this didn't seem to work when applied to B1
If A1 = Buy, then B1 value (whole number) when entered by the user needs to be stored as a negative number,and if A1 = Sell then B1 is stored as a positive number. I've looked at Data Validation Custom which allows a formula but this didn't seem to work when applied to B1