3 possible values

[Smokey_Vol]

=IF(F85>F84,"Winner","Loser")---- this is the formula that I'm currentl
using, but if a value has not yet been entered into cells F85 or F84 i
will still give me a Loser value. I understand why it is doing, but ho
can I have it put N/A if both values after still empty? Hopefully
explained it good enough.

_________
-Thanks
JeremyA

 

[Ron Coderre]

Try this:

=IF(OR(ISBLANK(F84),ISBLANK(F85)),"NA",IF(F85>F84,"Winner","Loser"))

Does that help?

Regards,
Ron

 

[Ron Coderre]

Another option:

=IF(COUNT(F84:F85)<2,"NA",IF(F85>F84,"Winner","Loser"))

Helping yet?

Regards,
Ro

 

[Smokey_Vol]

Try this:

=IF(OR(ISBLANK(F84),ISBLANK(F85)),"NA",IF(F85>F84,"Winner","Loser"))

Does that help?

Regards,
Ron

It worked. Thanks


Now I'm just trying to understand how

 

[Smokey_Vol]

Well I take that back.......... I getting N/A when it should be winner
and/or loser.

 

[Smokey_Vol]

My bad users error. The first formula does work.