validation using formula

Support
1

Can we configure validation using formula ?
If cell E8 is 0 then the F8 should be only 0,
but if Cell E8 is 1, then F8 can have input either 0 or 1.

2

Hi,

You could create a field and assign a conditional formula
IF(AND(E8=0,F8=0),“Y”,(IF(AND(E8=1,F8=0)),“Y”,(IF(AND(E8=1,F8=1)),“Y”,“N”))) to this field.
Then you could apply validation to the field, which the value should be Y.