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

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