Hi all gurus,
I need your help with my formula for validation:
=OR(IF(E13=1,N12>=13,N12<=20),IF(E13=2,N12>=20,N12<=80))
I have 2 options in cell E13, either 1 or 2.
If E13=1, then the value that the user can input in cell (N12) is between 13 to 20.
OR
If E13=2, then the value must be between 21 to 80.
Please look at the formula above, couldn't get it to work. I have try OR AND statements but no result.
Many thanks,
LV