View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RJ
 
Posts: n/a
Default how to make a formula ignore blank cells

Sounds like you need to add some logic to your formula for the case where the
cells are still blank. The following formula should help with that.

=IF(AND(k3=l3,AND(k3<"",l3<"")),1,"")

This will leave the cell blank in the case that k3 and l3 are not updated
yet and are still blank.
I do question your wanting to put a value of "1" if there is a tie. By
putting the one in quotes the field will be recognized as text in excel and
will not be helpful if you are planning on doing some calculations using
these numbers later. If you are planning on doing some calculations then I
would not include the quotes.

"Snap" wrote:

I'm trying to create a league table but the formula I'm using recognises
blank cells as zero - before any results are input.

My formula (for a tied game) is =if(k3=l3,"1") awarding 1 point for a tie /
draw.

However, my league table shows a tie / draw before the game is played! How
do I get the formula to ignore the cell until data is input?

Thanks in advance