Results 1 to 3 of 3

IF Function Question

Threaded View

  1. #1
    Registered User
    Join Date
    01-08-2011
    Location
    Southern California
    MS-Off Ver
    Excel 2007/Google Docs Spreadsheet
    Posts
    6

    IF Function Question

    Hello! I hope someone can help me. I am trying to set up a tournament bracket.

    I have this function in cell D16:

    =if(G7=D5,D9,if(G7=D9,D5,""))

    Until data is entered into cell G7, I do not want this function to return any value. I want this cell (D16) to be blank.

    The trouble I am having is that if D5 says "team1" but D7 and G7 are both empty at the moment, D16 will return the value "team1." I understand why this is happening, but I don't want it to happen. I want D16 blank until data is entered into G7.

    Hopefully someone can help and hopefully this makes sense.

    Thanks in advance!
    Last edited by mogabi; 01-08-2011 at 03:55 PM.

Thread Information

Users Browsing this Thread

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

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