LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do i auto create multiple files from 1 with multiple sheets Kathy Excel Worksheet Functions 0 July 26th 05 01:23 AM
Adding multiple worksheets Craig Excel Worksheet Functions 1 July 6th 05 07:21 PM
Can I get the mode, min, and max with multiple criteria? BobT Excel Discussion (Misc queries) 1 February 15th 05 03:20 AM
Displaying the results of multiple formulas in a single cell. gallegos1580 New Users to Excel 1 January 12th 05 04:14 PM
XML / parent with multiple children and with multiple children Richard Excel Discussion (Misc queries) 0 January 5th 05 11:49 AM


All times are GMT +1. The time now is 02:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"