Formula help

[hbomb]

hi guys,
in cell C1 I've entered the following:

=IF(A1>B1,"W",IF(A1=B1,"D",IF(A1<B1,"L")))

which returns a 'W', 'D' or 'L' value based on the data entered in A1 + B1 (0-9).
My problem is that C1 is returning a 'D' value even if no data is entered.
Is there a way to tweak my formula so that C1 remains blank and only returns a value when data is entered into A1 + B1?

thanks in advance

 

[Scott Huish]

Yes, and I'm going to give you a shorter formula for that:

=IF(COUNT(A1:B1)=2,TEXT(A1-B1,"\W;\L;\D"),"")

 

[hbomb]

Apologies for the delay in replying.
Thanks very much. That is perfect.

hbomb