CONDITIONAL STATEMENT

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BANJO - 31 Mar 2008 15:31 GMT

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, D5>8:00), "CHECK TIME" , D5)

I've tried other simple statements, but none work! Help!!

Signature

BANJO

Reply to this Message

David Biddulph - 31 Mar 2008 15:44 GMT

Perhaps you intended to say =IF(OR(D5<TIME(6,30,0), D5>TIME(8,0,0)), "CHECK
TIME", D5) ?

Signature

David Biddulph

> I'm trying to test a cell D5 which contains a time eg '07:00' to see if
> falls
[quoted text clipped - 5 lines]
>
> I've tried other simple statements, but none work! Help!!

Reply to this Message

Pete_UK - 31 Mar 2008 15:50 GMT

Try it like this:

=IF(OR(D5="",D5<TIME(6,30,0),D5>TIME(8,0,0)),"CHECK TIME",D5)

Hope this helps.

Pete

> 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
[quoted text clipped - 5 lines]
> --
> BANJO

Reply to this Message