Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |