Formula Help Needed . .
in [Functions]
|
Prev: how to remove page breaks from an existing document
Next: assign a macro to send email in lotus notes from Excel spreadsheet
From: Steve Dunn on 7 May 2010 09:25 =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 7 May 2010 10:44
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. > >> > > >> > |