 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / December 20053 possible values
=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  SignatureRon Coderre Another option: =IF(COUNT(F84:F85)<2,"NA",IF(F85>F84,"Winner","Loser")) Helping yet? Regards, Ro Ron Coderre Wrote: > Try this: > [quoted text clipped - 4 lines] > Regards, > Ron It worked. Thanks Now I'm just trying to understand how -- Smokey_Vo Well I take that back.......... I getting N/A when it should be winner and/or loser. SignatureSmokey_Vol |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.