| Home |
| Search |
| Today's Posts |
|
#1
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hiding zero values in charts | Charts and Charting in Excel | |||
| Keeping a cell value constant trhoughout a list of values | Excel Worksheet Functions | |||
| Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
| #N/A Values : Returned by Formulas vs Entered Manually | Charts and Charting in Excel | |||
Threaded Mode
