Hi,
I have a footie scoring system as follows
Forecast Actual Points Awarded
C D F G
2-1 2-1 6 (a) full result correct
2-2 2-2 6 (b) full result correct
3-1 3-1 4 (c) result + 1 team score
1-2 1-2 4 (d) result + 1 team score
3-1 2-0 2 (e) result + no team score
1-3 0-4 2 (f) result + no team score
2-2 0-0 2 (g) result + no team score
3-1 1-3 0 (h) no result + no team score
I have devised following IF statements for above which seem to work fine individually but when I try and put together (tried several ways) I keep getting formula error message. Tried nesting and also using 'AND' and 'OR' after each IF. (but without the zeros (except last one)
IF(AND(C1=F1,D1=G1),6,0) (a & b)
IF(AND(C1=F1,D1<>G1),4,0) (c)
IF(AND(C1<>F1,D1=G1),4,0) (d)
IF(AND(C1<>F1,D1<>G1,C1>D1,F1>G1),2,0) (e)
IF(AND(C1<>F1,D1<>G1,C1<D1,F1<G1),2,0) (f)
IF(AND(C1<>F1,D1<>G1,C1=D1,F1=G1),2,0) (g)
Would like to put all together so one formula checks and awards the corresponding score.
Any help appreciated
thanks