3 possible values

  • Thread starter Thread starter Smokey_Vol
  • Start date Start date
S

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
 
Try this:

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

Does that help?

Regards,
Ron
 
Another option:

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

Helping yet?

Regards,
Ro
 
Ron said:
Try this:

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

Does that help?

Regards,
Ron
Click to expand...


It worked. Thanks


Now I'm just trying to understand how
 
Back
Top