| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I write a formula to pick a date or N/A?
I am using a spreadsheet to show when required tasks are due for specific
classes. My problem is this: when a class does not go through a specific portion, I put N/A in the date block for that portion, and would like it to put N/A in the specific date blocks for the specific tasks, not the date the task is due. So what I am getting is "#value!". Thanks Scott |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Please help | Excel Worksheet Functions | |||
| Can I write an excel formula to display the file save date? | Excel Worksheet Functions | |||
| date that updates itself daily, plus another formula please?? | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Value between 2 dates | Excel Worksheet Functions | |||
Threaded Mode
