Trying to use the formula below and get an error message saying I've entered too many arguments for this function. See formula below:
=IF(AND(AI2<TIME(3,0,0),AJ2="NO"),"YES","NO"),IF(AND(AI2>TIME(3,0,0),AJ2="YES"),"YES","NO"))
For context, the criteria are satisfied if time is less than 3 hours and AJ2 = NO, but the criteria are also meet if time is greater than 3 hours and AJ2 = YES. Any help would be appreciated!
Bookmarks