Hi everyone

I have a formula
Formula: copy to clipboard 
=IF(O3="6"+0,"Yes",IF(O3="7"+0,"Yes",IF(O3="","",IF(OR(N3<"07:00",N3>="16:00"),"Yes","No"))))


which works perfectly to highlight if a job was attended to in Standby time however I have added a column which shows cancelled job as "Yes" "No" I now want my formula to look at
If S3 (Cancelled column) = YES then the overall formula will return "No" in the standby column

I tried
Formula: copy to clipboard 
=IF(O3="6"+0,"Yes",IF(O3="7"+0,"Yes",IF(O3="","",IF(S3="Yes","No",IF(OR(N3<"07:00",N3>="16:00"),"Yes","No")))))
which works other than on the first two conditions. i am afraid i cannot upload a sheet at present as I'm at work.

Any suggestions

Thanks

Kelly