I
ibbm
I am trying to write a conditional statement where if a the time in cell D4
is between range1(G7-H7) or range2(I7-J7) then say YES else leave blank.
I'm trying if(and(d4>=G7, d4<=H7), "YES"," ") which works but I don't know
how to get the OR in their.
Any help you give me will be so appreciated!
Thanks in advance.
is between range1(G7-H7) or range2(I7-J7) then say YES else leave blank.
I'm trying if(and(d4>=G7, d4<=H7), "YES"," ") which works but I don't know
how to get the OR in their.
Any help you give me will be so appreciated!
Thanks in advance.