If statement
Your syntax error is at
IF(D53*24=13<=17,...
where, if you needed that condition, it would need to be
IF(AND(D53*24=13,D53*24<=17),...
but you don't need =13 when you've already trapped <=13 in the previous
test.
Try =IF((D53*24)<=13,"1",IF(D53*24<=17,"2","3"))
Also bear in mind that your answers "1", "2", "3" are text. if you want
them as numbers, remove the double quotes.
--
David Biddulph
"Kev" wrote in message
...
Please can someone help me on this, I have been struggling with this for
hours and can't find a solution. I want to display a 1 if the time is
before
13:00 and a 2 if the time is between 13:00 and 17:00 and a 3 if the time
is
after 17:00 but I cannot get the if statement to give me the correct
result
between 13:00 and 17:00. I have tried this but it won't work
=IF((D53*24)<=13,"1",IF(D53*24=13<=17,"2",IF(D53* 24=17,"3")))
a
10:00:28
10:01:30
10:02:47
13:00:02
13:12:57
13:19:25
17:06:52
17:11:27
17:14:27
|