+ Reply to Thread
Results 1 to 4 of 4

How do I make blank cells not be equal?

Hybrid View

  1. 10-03-2014, 03:08 PM #1
    afe5026
    afe5026 is offline
    Registered User
    Join Date
    10-03-2014
    Location
    USA
    MS-Off Ver
    MS Office 2013
    Posts
    7

    How do I make blank cells not be equal?

    Hello,
    I am in the process of creating the table for a soccer league. I have a formula that takes the goals for and goals against and determines if it is a win, tie, or loss. However, when there is no data in the goals for or against cells, the formula yields a tie. Is there any way to make the formula not have a value until there is values in the goals for and against cells?

    The formula I'm using for determining win, draw, or loss is =IF(D5>E5,"W",IF(E5>D5,"L",IF(D5=E5,"D")))

    D5= Goals for
    E5= Goals Against

    Feel free to reply with a response or a question if you need clarification. Thanks!
    Reply With QuoteRegister To Reply
  2. 10-03-2014, 03:32 PM #2
    judgeh59
    judgeh59 is offline
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: How do I make blank cells not be equal?

    does this get you closer? I removed your last IF statement because it's not really needed....

    =IF(OR(D5="",E5=""),"",IF(D5>E5,"W",IF(E5>D5,"L","D")))
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....
    Reply With QuoteRegister To Reply
  3. 10-03-2014, 03:34 PM #3
    afe5026
    afe5026 is offline
    Registered User
    Join Date
    10-03-2014
    Location
    USA
    MS-Off Ver
    MS Office 2013
    Posts
    7

    Re: How do I make blank cells not be equal?

    Thank you so much! That's what I needed. Greatly appreciated!
    Reply With QuoteRegister To Reply
  4. 10-03-2014, 03:37 PM #4
    judgeh59
    judgeh59 is offline
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: How do I make blank cells not be equal?

    my pleasure......glad I could help....have a a great day...

    If this has been completed to your satisfaction, please set the thread to Solved...If you feel I deserve an increase in my reputation, feel free to click on the star in the lower left of the thread. Remember, someday when you help somebody they may add to your rep points, and it could be me...just a thought...
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. If Statement to make a blank cell be equal to 0 even though it has a formula in it
    By thanhie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-08-2013, 11:19 PM
  2. Excel 2007 : How can I make two cells completely equal
    By mloreto in forum Excel General
    Replies: 1
    Last Post: 10-20-2011, 11:33 PM
  3. Excel 2007 : Assistance on Ranking Formula to make blank values equal to zero
    By michelbalendo in forum Excel General
    Replies: 9
    Last Post: 07-13-2011, 09:59 AM
  4. Make cells equal 1
    By PJenkins in forum Excel General
    Replies: 5
    Last Post: 05-30-2007, 12:05 AM
  5. [SOLVED] How do I make a cell equal to another cells value and not it's fo.
    By TroutKing in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-17-2005, 03:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1