View Single Post
  #1   Report Post  
crossroader35
 
Posts: n/a
Default 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