IF formula to return blanks

[mike_ate_a_pie]

Hi all,

I'm trying to build a formula to return 0,1 or 3 depending on the values entered into C9,D9. Its a football scorecard!

However it reurns 1 when the values in C9,D9 are blanks or text. How do I get the formula to ignore the cells when C9,D9 have no scores in yet.

=IF(C9=D9,1,IF(C9>D9,3,IF(D9>C9,3,0)))

Cheers lads,

 

[lenze]

=IF((N(C9))*(N(D9)),IF(C9=D9,1,IF(C9>D9,3,0)),"")

lenze

 

[Special-K99]

Your orignal formula is incorrect 0 will never occur.
If C9 = D9 then 1 is ok.
If C9 < > D9 then either C9 > D9 or D9 > C9 both of which result in 3 so 0 will never occur in your formula.

Try this instead

=IF(OR(C9="",D9=""),"",IF(C9=D9,1,3))

 

[mike_ate_a_pie]

cheers guys, great stuff.