| Home |
| Search |
| Today's Posts |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF, AND, BUT and ON-THE-OTHER-HAND formula :)
Thanks for the update
-- "T. Valko" wrote: In the formula, you can do without the 1* and still get the correct result. -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... See this screencap: http://img119.imageshack.us/img119/5356/scoresdb9.jpg -- Biff Microsoft Excel MVP "JockW" wrote in message ... I'm unsure if this is do-able, but I know some of you will relish the challenge.... I'm creating a spreadsheet showing points gained from predicting soccer scores. For the correct result (ie home win, away win or draw) - 3 points, For getting home team score correct - 1 point, For getting away team score correct - 1 point. Therefore, the max possible points per game would be 5. So, for instance: Home Away 3 1 john's prediction 2 1 4 points - 3 for the result and 1 for the correct away score Jane's prediction 1 0 3 points for the correct result Jack's prediction 0 3 0 points I think there may be too many variables but any/all help greatly appreciated. -- tia |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why hand pointer in one and not the other | Excel Discussion (Misc queries) | |||
| Can someone give me a hand with this formula please? | Excel Worksheet Functions | |||
| Icon is a hand permanently | Excel Worksheet Functions | |||
| y-axis moves from the left hand side to the right hand side | Excel Discussion (Misc queries) | |||
| y-axis moves from the left hand side to the right hand side! | Charts and Charting in Excel | |||
Threaded Mode
