excelbytes
Active Member
- Joined
- Dec 11, 2014
- Messages
- 251
- Office Version
- 365
- Platform
- Windows
I am trying to use Data Validation to restrict inaccurate entries. The current issue I have is between columns A, B, and C. Here are the conditions for column C:
C must not be greater than A
C must be in multiples of 100
C minimum value must be 100
IF there is a value in B (B is optional), then C must be less than B, else just the first three conditions.
The logical formula would be:
=AND(C1<=A1,MOD(C1,100)=0,C1>=100,IF(ISNUMBER(B1),C1<B1))
I assume the last variable in the AND function is invalid for Data Validation. How can I accomplish this?
Thanks.
C must not be greater than A
C must be in multiples of 100
C minimum value must be 100
IF there is a value in B (B is optional), then C must be less than B, else just the first three conditions.
The logical formula would be:
=AND(C1<=A1,MOD(C1,100)=0,C1>=100,IF(ISNUMBER(B1),C1<B1))
I assume the last variable in the AND function is invalid for Data Validation. How can I accomplish this?
Thanks.