3 possible values
 

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

_________
-Thanks
JeremyA-


--
Smokey_Vol
------------------------------------------------------------------------
Smokey_Vol's Profile: http://www.excelforum.com/member.php...o&userid=29717
View this thread: http://www.excelforum.com/showthread...hreadid=494312

3 possible values
 

Try this:

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

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=494312

3 possible values
 

Another option:

=IF(COUNT(F84:F85)<2,"NA",IF(F85F84,"Winner","Los er"))

Helping yet?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=494312

3 possible values
 

Ron Coderre Wrote:
Try this:

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

Does that help?

Regards,
Ron


It worked. Thanks


Now I'm just trying to understand how?


--
Smokey_Vol


------------------------------------------------------------------------
Smokey_Vol's Profile: http://www.excelforum.com/member.php...o&userid=29717
View this thread: http://www.excelforum.com/showthread...hreadid=494312

3 possible values
 

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


--
Smokey_Vol


------------------------------------------------------------------------
Smokey_Vol's Profile: http://www.excelforum.com/member.php...o&userid=29717
View this thread: http://www.excelforum.com/showthread...hreadid=494312

3 possible values
 

My bad users error. The first formula does work.


--
Smokey_Vol


------------------------------------------------------------------------
Smokey_Vol's Profile: http://www.excelforum.com/member.php...o&userid=29717
View this thread: http://www.excelforum.com/showthread...hreadid=494312