Formula Problem

D

Daveo

Hi there,

Can anyone tell me what is wrong with the following formula (it's doing
my nut in!):

IF([DAY]<>"Y",0,IF(OR((OR((AND((OR([START1]<=7,[START1]<8)),([END1]>7))),
(AND((OR([START2]<=7,[START2]<8)),([END2]>7))))),(OR((AND((OR([START3]<=7,[START3]<8)),([END3]>7))),
(AND((OR([START4]<=7,[START4]<8)),([END4]>7)))))),1,0)

I've replace cell refs with [x..]'s.

Many thanks - David
 
G

Guillermo Worlicek

It seems that there is a parenthesis missing at the end.
Best,
Guillermo
 
Top