using & in IF statements??

[nenonena]

I am trying to compare stats from games and am looking for correlation
in the data. e.g. =IF(D1>D2 & E1>E2,1,IF(D1>D2 & E1=E2,0,-1)) Can I d
& here?? The D column is the score of the game and E-L are al
specific stats. How do I best run formulas so I can see out of say 10
games the results would be something like

D1>D2 & E1>E2= 40
D2>D1 & E2>E1= 30
D1>D2 & E1<=E2 = 10
D2>D1 & E2<=E1 = 20

then I would like to add more colums into the formula, say E> and H
and D> etc.

Thank

 

[Bob Phillips]

No you use AND

=IF(AND(D1>D1, E1>E2), etc.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[AlfD]

Hi!

If I get your drift you are looking for something like this:

=if(AND(D1>D2,E1>E2),"Yes","No")

This reads " if both D1> D2 and E1>E2, put "Yes" otherwise put "No""

Come back if that's not the line.

Al

 

[nenonena]

THANKS, THAT IS EXACTLY WHAT I WAS LOOKING FOR. A FRIEND SENT ME TH
SAME INFO YESTERDAY BUT I APPRECIATE THE RESPONSE

 

[AlfD]

Hi!

You're welcome.

Al