1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: If Formula Maybe?

Discussion in 'Business Applications' started by floydcojacket, Apr 4, 2010.

Thread Status:
Not open for further replies.
Advertisement
  1. floydcojacket

    floydcojacket Thread Starter

    Joined:
    Jul 4, 2008
    Messages:
    278
    Cell A1..home team score
    Cell B1..Visitor team score
    Cell C1..either W or L depending whether A1>B1 or A1<B1
    A1=10
    B1=1
    C1=W
    A1=1
    B1=10
    C1=L
    Please advise how to put in a formula in C1 to show either W or L.
    Thank you for your help.
     
  2. cwwozniak

    cwwozniak Trusted Advisor Spam Fighter

    Joined:
    Nov 28, 2005
    Messages:
    64,620
    First Name:
    Chuck
    Assuming you are using some recent version of MS-Excel, the following formula should work for you. I added the case where if the scores are equal, the result is a "T" for a tie. There is no checking to see if A1 and/or B1 is blank.

    =IF(A1>B1,"W",IF(A1<B1,"L","T"))
     
  3. floydcojacket

    floydcojacket Thread Starter

    Joined:
    Jul 4, 2008
    Messages:
    278
    Thank you very much.
    Amazing how many ways I tried to do this incorrectly and see the correct way to be so simple.
    WOW
    Thanks again.
     
  4. cwwozniak

    cwwozniak Trusted Advisor Spam Fighter

    Joined:
    Nov 28, 2005
    Messages:
    64,620
    First Name:
    Chuck
    You're welcome.

    Thank you for clearly explaining exactly what you needed. It made it easy to come up with the correct formula on the first try.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/914733

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice