| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF with function as false return
I am creating a to do list in Excel 2003. I have 3 columns, A "Finished" with
x if complete; B "Due Date" with a date; C "Days to Go". I want the Days to Go to read Done if there is an x in column A. I don't want to just delete the completed tasks as I need a record of what I do. I tried in C =IF(a4,"x", Done",=b4-TODAY()) The =B4-TODAY() works unless I want to factor in my status from A. Any ideas? The Help says a formula can be the result for a FALSE return, but I cannot find any examples. Of course I could just hide the completed tasks, but that doesn't let me play with formulas. -- Regards, Lyn "Any sufficiently advanced technology is indistinguishable from magic." AC Clark |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to return a number instead of true/false with an if function? | New Users to Excel | |||
| FIND function, when FALSE how can you return nothing (" ") instead of#VALUE or #NAME | Excel Discussion (Misc queries) | |||
| IF function - need FALSE to return a blank cell, not 0 | Excel Worksheet Functions | |||
| LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) | |||
| Function to return True/False if all are validated as True by ISNU | Excel Worksheet Functions | |||
Threaded Mode
