| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return null
I am trying to return a null value (blank cell) for this report.
A B C D No. Final sent date Status Final filed - month 17 3-Mar-08 Completed Mar 18 9-Jan-08 Completed Jan 19 (blank) In progress Jan 20 (blank) In progress Jan My problem: I have the formula =TEXT(C10,"mmm") in the "Final Filed - month" column I want to result in for item no. 19 and 20 to be blank in column D instead of stating Jan (which is incorrect). Please, what is the formula? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare Value in Cell 1 to a List, Return Value if Match otherwise Return Null | Excel Discussion (Misc queries) | |||
| Have DGET return Null instead of #Value! | Excel Worksheet Functions | |||
| Cell to return null instead of 0 | Excel Discussion (Misc queries) | |||
| need Lookup table to return null or zero | Excel Worksheet Functions | |||
| return a " " for null values | Excel Worksheet Functions | |||
Threaded Mode
