Custom Validation Criteria

Originally Posted by AHaigh1042

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 .

Thanks in Advance

50<=50 part ?

50<=J10 is the same as J10>=50

hth
---