Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CONDITIONAL STATEMENT
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CONDITIONAL STATEMENT
Try it like this:
=IF(OR(D5="",D5<TIME(6,30,0),D5TIME(8,0,0)),"CHEC K TIME",D5) Hope this helps. Pete On Mar 31, 3:31*pm, BANJO wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Statement | Excel Worksheet Functions | |||
Conditional Statement | Excel Worksheet Functions | |||
Conditional If statement | Excel Worksheet Functions | |||
conditional statement | New Users to Excel | |||
Conditional if statement | Excel Worksheet Functions |