View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Smokey_Vol
 
Posts: n/a
Default 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