+ Reply to Thread
Results 1 to 2 of 2

Attributing a value to winning/losing cells

  1. #1
    Registered User
    Join Date
    04-16-2007
    Posts
    12

    Attributing a value to winning/losing cells

    Hi

    I'm trying to find a formula that will add a Win or Lose value depending if a team won or lost their game. I've attached an example. How I have it currently is under the Start sheet and how I want it to look is under the Finish sheet.
    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 365
    Posts
    2,406

    Re: Attributing a value to winning/losing cells

    For Home (E2):
    =IF($C2<$D2,"L","W")

    For Away (F2):
    =IF($C2>$D2,"L","W")

    and dragged down as necessary

    regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Winning and Losing streaks in same column
    By troglodytes in forum Excel General
    Replies: 7
    Last Post: 03-27-2014, 10:34 PM
  2. winning/losing streak without dates in order
    By chemmiah in forum Excel General
    Replies: 3
    Last Post: 01-28-2011, 11:57 PM
  3. Replies: 4
    Last Post: 08-21-2010, 09:09 PM
  4. Calculating Longest winning and losing streak.
    By Lewis Koh in forum Excel General
    Replies: 2
    Last Post: 07-27-2009, 08:43 AM
  5. [SOLVED] Winning & Losing Streaks
    By Mike in forum Excel General
    Replies: 3
    Last Post: 04-12-2005, 02:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1