Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Displaying multiple outcomes
I am currently building a spreadsheet to help track progress and other
information for a local sports club. What I need is a formula that will all me to display one of three outcomes, win/loss/draw from two variables i.e Points for and points against. if for instance cell A1 is a value for "Points for" and cell a2 is a value for "Points against", then I wish to display either win/loss/draw depending on whether a1a2, a1<a2 or a1=a2. Can anyone help by providing me with a formula for such Thanks Crossroader35 |
#2
|
|||
|
|||
One way:
=IF(A1A2,"Win",IF(A1<A2,"Loss","Draw")) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "crossroader35" wrote in message ... I am currently building a spreadsheet to help track progress and other information for a local sports club. What I need is a formula that will all me to display one of three outcomes, win/loss/draw from two variables i.e Points for and points against. if for instance cell A1 is a value for "Points for" and cell a2 is a value for "Points against", then I wish to display either win/loss/draw depending on whether a1a2, a1<a2 or a1=a2. Can anyone help by providing me with a formula for such Thanks Crossroader35 |
#3
|
|||
|
|||
Just another play to tinker with for the 3 outcomes ..
Assume you have in A1:B4 where A1:B1 holds the players' names (eg: AA and BB) A2:B2, A3:B3 etc holds the scores of each round's play AA BB 50 60 60 50 60 60 etc We could put in C2: =IF(OR(A2="",B2=""),"",VLOOKUP(SIGN(A2-B2),{0,"Draw";1,"AA wins";-1,"BB wins"},2,0)) and copy C2 down, to yield the results, viz.: AA BB 50 60 BB wins 60 50 AA wins 60 60 Draw etc -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "crossroader35" wrote in message ... I am currently building a spreadsheet to help track progress and other information for a local sports club. What I need is a formula that will all me to display one of three outcomes, win/loss/draw from two variables i.e Points for and points against. if for instance cell A1 is a value for "Points for" and cell a2 is a value for "Points against", then I wish to display either win/loss/draw depending on whether a1a2, a1<a2 or a1=a2. Can anyone help by providing me with a formula for such Thanks Crossroader35 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i auto create multiple files from 1 with multiple sheets | Excel Worksheet Functions | |||
Adding multiple worksheets | Excel Worksheet Functions | |||
Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
Displaying the results of multiple formulas in a single cell. | New Users to Excel | |||
XML / parent with multiple children and with multiple children | Excel Discussion (Misc queries) |