Results 1 to 3 of 3

Thread: Formula problem counting blank cell.
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Dec 2012
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Formula problem counting blank cell.

    Hi All,

    I am running a football tournament and want to automate the data as much as possible. I have created a spread sheet to show the table, but I am struggling to get the Win/Lose/draw to work correctly.

    I am using the following formula in K3, where J3 is the home score and J4 is the away:

    =IF(J3>J4,"W",IF(J3
    This works for the "W" and "L" part, but if the cell is blank it counts it as a D as they are equal and awards 1 point to the overall table. I need it to leave the cell K3 blank if J3 and J4 are blank.

    Any idea how I can do this please?

    Thanks in advance
    Rusty

  2. #2
    New Member
    Join Date
    Dec 2012
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Formula problem counting blank cell.

    The formula should be:

    =IF(J4>J5,"W",If(J4

  3. #3
    New Member
    Join Date
    Dec 2012
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Formula problem counting blank cell.

    Why can't i put the formula in??

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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