From: Steve Dunn on
=if((Fixtures!C7="")+(Fixtures!D7=""),"",((Fixtures!C7>Fixtures!D7)*(B4>C4)+(Fixtures!C7<Fixtures!D7)*(B4<C4)+(Fixtures!C7=Fixtures!D7)*(B4=C4))+2*(B4=Fixtures!C7)*(C4=Fixtures!D7))


"J.Scargill" <JScargill(a)discussions.microsoft.com> wrote in message
news:2F0DF574-89D0-4E7B-B3A6-E04BB5E77E51(a)microsoft.com...
> Steve,
>
> Only minor problem I have now is that all predictions of a draw are
> returning a 1 or a 3 because the cells they are pulling from are blank!
>
> Can you suggest anything to cure this? It will cause a problem when I come
> to populate the league table as it will count the 1s and 3s on games that
> havent been played and invalidate the individuals score.
>
> "Steve Dunn" wrote:
>
>> You're welcome, glad to help.
>>
>> "J.Scargill" <JScargill(a)discussions.microsoft.com> wrote in message
>> news:15DF0596-D70E-4863-B0D4-6275F863A247(a)microsoft.com...
>> > Steve, that is fantastic! Works like a dream.
>> >
>> > Thankyou very much.
>> >
>>

From: J.Scargill on
Again, thanks Steve.

"Steve Dunn" wrote:

> =if((Fixtures!C7="")+(Fixtures!D7=""),"",((Fixtures!C7>Fixtures!D7)*(B4>C4)+(Fixtures!C7<Fixtures!D7)*(B4<C4)+(Fixtures!C7=Fixtures!D7)*(B4=C4))+2*(B4=Fixtures!C7)*(C4=Fixtures!D7))
>
>
> "J.Scargill" <JScargill(a)discussions.microsoft.com> wrote in message
> news:2F0DF574-89D0-4E7B-B3A6-E04BB5E77E51(a)microsoft.com...
> > Steve,
> >
> > Only minor problem I have now is that all predictions of a draw are
> > returning a 1 or a 3 because the cells they are pulling from are blank!
> >
> > Can you suggest anything to cure this? It will cause a problem when I come
> > to populate the league table as it will count the 1s and 3s on games that
> > havent been played and invalidate the individuals score.
> >
> > "Steve Dunn" wrote:
> >
> >> You're welcome, glad to help.
> >>
> >> "J.Scargill" <JScargill(a)discussions.microsoft.com> wrote in message
> >> news:15DF0596-D70E-4863-B0D4-6275F863A247(a)microsoft.com...
> >> > Steve, that is fantastic! Works like a dream.
> >> >
> >> > Thankyou very much.
> >> >
> >>
>