|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 17th, 2005, 04:14 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
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 
|
|
#2
December 17th, 2005, 04:18 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
December 17th, 2005, 04:20 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
|
|
#4
December 17th, 2005, 04:37 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
|
|
#5
December 17th, 2005, 04:42 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
|
|
#6
December 17th, 2005, 04:57 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Using the values of a crosstab query to create new values | relacy | Running & Setting Up Queries | 1 | December 15th, 2005 10:29 PM |
| Keeping a cell value constant trhoughout a list of values | borikua05 | Worksheet Functions | 2 | December 3rd, 2005 03:03 PM |
| default values in queries | Jeff B | Running & Setting Up Queries | 11 | March 3rd, 2005 12:49 AM |
| Average only some values | Andreas | Worksheet Functions | 2 | February 18th, 2004 10:56 AM |
| finding distinct values from two lists | Frank Kabel | Worksheet Functions | 0 | February 14th, 2004 12:41 AM |
Linear Mode
