Posted to microsoft.public.excel.worksheet.functions

banjo

external usenet poster

Posts: 2

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Statement	regdor	Excel Worksheet Functions	8	January 4th 08 09:36 PM
Conditional Statement	lbraddock	Excel Worksheet Functions	0	July 16th 07 10:16 PM
Conditional If statement	Dan	Excel Worksheet Functions	0	March 26th 06 11:46 PM
conditional statement	mjstizzle	New Users to Excel	1	June 29th 05 05:18 PM
Conditional if statement	Matt Stanley	Excel Worksheet Functions	2	November 10th 04 04:47 AM

All times are GMT +1. The time now is 01:00 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us