how to make a formula ignore blank cells
Try this, assuming the scores are placed in K3 and I3:
=IF(OR(K3="",I3=""),"",IF(K3=I3,"1"))
This gives a blank if either K3 or I3 are blank. Your formula does not
check for K3 being larger or smaller than I3.
Hope this helps.
Pete
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
|