if & and functions

[Dominique Feteau]

how could i word this:

i want an if statement that'll look at a cell (lets say D2) and say "if D2
is less than 10am, enter 'Before 10am' in F2, if D@ is greater than 10am but
greater than 3pm, enter 'Between 10am & 3pm' in F2 and if D2 is greater than
3pm, enter 'After 3pm' in F2.

thanx in advance.
dominique

 

[Bob Phillips]

Hi Dominique,

=IF(D2<TIME(10,0,0),"Before
10am",IF(AND(D2>=TIME(10,0,0),D2<TIME(15,0,0)),"Between 10am & 3pm","After
3pm"))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)