Formula Problem

[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

[Guillermo Worlicek]

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


"Daveo" <[email protected]> wrote in message
news:[email protected]...
> 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
>