View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
banjo banjo is offline
external usenet poster
 
Posts: 2
Default 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