You have a third to try now as wellI have triied both the formulas suggested ( I have set the format for the cell to “Number”), but both formulas display in the cell when I press enter.
=IF(OR(AND(G3=H3,I3=J3),AND(G3<H3,I3<J3),AND(G3>H3,I3>J3)),5,0)
I think you'll need to show us the exact formula you used in that screen shot as the formula I posted in post #12 and the formula from Fluff in post #11 seem to give the results you say you expect.some of the results are incorrect
Book1 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
G | H | I | J | K | L | M | N | O | |||
1 | Prediction | Actual | Correct | ||||||||
2 | H | A | H | A | Post #11 | Post #12 | |||||
3 | 3 | 0 | 2 | 0 | 5 | 5 | |||||
4 | 2 | 1 | 1 | 2 | 0 | 0 | |||||
5 | 2 | 1 | 4 | 0 | 5 | 5 | |||||
6 | 5 | 1 | 4 | 1 | 5 | 5 | |||||
7 | 0 | 1 | 2 | 3 | 5 | 5 | |||||
8 | 0 | 1 | 0 | 2 | 5 | 5 | |||||
9 | 2 | 3 | 0 | 3 | 5 | 5 | |||||
10 | 1 | 1 | 1 | 1 | 5 | 5 | |||||
11 | 1 | 0 | 0 | 4 | 0 | 0 | |||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
N3:N11 | N3 | =(SIGN(G3-H3)=SIGN(I3-J3))*5 |
O3:O11 | O3 | =IF(OR(AND(G3=H3,I3=J3),AND(G3<H3,I3<J3),AND(G3>H3,I3>J3)),5,0) |