| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF, AND, BUT and ON-THE-OTHER-HAND formula :)
I don't get it, but it works....
thanks. "David Biddulph" wrote: If the actual result is in cells B2 and C2 (home & away), and the predictions from your contestants are in the same columns in rows 4 onwards, then in D4 you can put the formula =3*(SIGN(B4-C4)=SIGN(B$2-C$2))+(B4=B$2)+(C4=C$2), and copy down as required. -- David Biddulph "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
