My Account
Sign up, and you'll be able to ignore users whose posts you don't want to see.
Sign up
Report problem with this ad
Start a related thread
Start a related poll
Reply via Boardmail
Mar 31, 2015
8:00
:08
pm
Yoshinobu
Here's what it should look like
=IF(AND($F2="SHIFT",(J$1>=$G2),(J$1<=$H2)),1,IF(AND($F2="LUNCH",(J$1>=$G2),(J$1<=$H2)),-1,""))
Start a related thread
Start a related poll
Reply via Boardmail
Report problem with this ad
Yoshinobu
Previous username
Lhandroval
New username
Psalm Trees
Bio page
Yoshinobu
Joined
Nov 2, 2008
Last login
Jan 5, 2020
Total posts
0 (0 FO)
Report problem with this ad
Messages
Author
Time
Excel HELP! - Formula Question
tarmstrong
3/31/15 7:29pm
Nest a second IF in the third argument of the outer IF
Yoshinobu
3/31/15 7:38pm
If I understand correctly this is what I did...
tarmstrong
3/31/15 7:42pm
Well, yeah, now the outer IF has 4 arguments
Yoshinobu
3/31/15 7:48pm
Here's what it should look like
Yoshinobu
3/31/15 8:00pm
That did the trick - You're the best - Thanks for the help
tarmstrong
3/31/15 8:02pm
Report problem with this ad
Posting on CougarBoard
In order to post, you will need to either
sign up
or
log in
.
Report problem with this ad