Formula problem counting blank cell.

[rusty21]

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<J4,"L",IF(J3=J4,"D")))

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

 

[rusty21]

The formula should be:

=IF(J4>J5,"W",If(J4<J5,"L",IF(J4=J5,"D")))

 

[rusty21]

Why can't i put the formula in??