Mar 31, 2015
7:42:34pm
7:42:34pm
If I understand correctly this is what I did...
=IF(AND($F2="SHIFT",(J$1>=$G2),(J$1<=$H2)),1,"",IF(AND($F2="LUNCH",(J$1>=$G2),(J$1<=$H2)),-1,""))
but it says "You've entered too many arguments for this function
but it says "You've entered too many arguments for this function
- Bio page
- tarmstrong
- Joined
- Oct 1, 2004
- Last login
- May 5, 2024
- Total posts
- 8,154 (15 FO)
