Hi everyone,
I am validating some cells that are depenedant on the values in the adjacent column. i.e. If people work under 50 hours in column I they are only entitled to a travel allowance of $50 or below. If they work 50 hours or above they are entitled to between $50 - $100.
I have entered the custom validation of =IF(I10<50,J10<=50,AND(J10>=,J10<=120)) which seems to work fine.
However, I have seen it enetered elsewhere as =IF(I10<50,J10<=50,AND(50<=J10,J10<=120)) which also works. My basic question is, how does his second way work, I don't understand th 50<=50 part.
Thanks in Advance
Bookmarks