CONDITIONAL STATEMENT
Perhaps you intended to say =IF(OR(D5<TIME(6,30,0), D5TIME(8,0,0)), "CHECK
TIME", D5) ?
--
David Biddulph
"BANJO" wrote in message
...
I'm trying to test a cell D5 which contains a time eg '07:00' to see if
falls
within a time range or is blank or to print it if it is within range.
Excel
indicates an error???
=if(or(D5, 06:30, D58:00), "CHECK TIME" , D5)
I've tried other simple statements, but none work! Help!!
--
BANJO
|