nested if statements using "AND" as well as "OR"

  • Thread starter Thread starter ibbm
  • Start date Start date
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.
 
Back
Top