Home |
Search |
Today's Posts |
#1
|
|||
|
|||
compare results
In a soccer tournament predications are made by individuals of the score for
each game. Points are awarded to each individuals accuracy in predicting the outcome of each game using: correct score in the game- 3 points; correct result (i.e.prediction of a home or away win regardless of score) - 1 point; any other result - 0 points. The most points that can be awarded in any prediction is therefore 3. Does anyone have a spreadsheet or formula that can show this on a spreadsheet. I have about 40 forms to check from individuals - I know Excel can do this! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Vlookup to compare and validate data | Excel Worksheet Functions | |||
calculating results in formulas | Excel Discussion (Misc queries) | |||
How can I compare Excel files | Excel Discussion (Misc queries) | |||
Is there a way to compare 2 spreadsheets with Excel? | Excel Discussion (Misc queries) | |||
Compare 2 Worksheets Create a 3rd depending on results | Excel Discussion (Misc queries) |