Am trying to get a data validation to work. Has a few conditions.
I want to Validate A1, B1, and C1 as follow
A1 must be either Y or N.
B1 must be either Y or N.
C1 must be a numerical Value.
Only A1 or B1 can have a Y or N at any one time.
If A1 or B1 has a Y or N, C1 can only be 0. If A1 AND B1 are empty, C1 can be any number.
Any ideas?
I want to Validate A1, B1, and C1 as follow
A1 must be either Y or N.
B1 must be either Y or N.
C1 must be a numerical Value.
Only A1 or B1 can have a Y or N at any one time.
If A1 or B1 has a Y or N, C1 can only be 0. If A1 AND B1 are empty, C1 can be any number.
Any ideas?