| 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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Return null
Should your formula refer to B10 and Not C10 as C10 is the status ??
Assuming it should be column B, use =IF(ISBLANK(B10),"",TEXT(B10,"mmm")) "Karen" wrote: 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Return null
Thanks Dennis. That was great!
What if column B row 19 shows the value of 1/0/1900 (which returns 0-Jan-00 in date format). What would my formula be? A B 17 3-Mar-08 Completed Mar 19 0-Jan-00 In progress Jan Karen "Dennis" wrote: Should your formula refer to B10 and Not C10 as C10 is the status ?? Assuming it should be column B, use =IF(ISBLANK(B10),"",TEXT(B10,"mmm")) "Karen" wrote: 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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Return null
Try this
=IF(OR(ISERROR(DAY(B19)),ISBLANK(B19)),"",TEXT(B19 ,"mmm")) "Karen" wrote: Thanks Dennis. That was great! What if column B row 19 shows the value of 1/0/1900 (which returns 0-Jan-00 in date format). What would my formula be? A B 17 3-Mar-08 Completed Mar 19 0-Jan-00 In progress Jan Karen "Dennis" wrote: Should your formula refer to B10 and Not C10 as C10 is the status ?? Assuming it should be column B, use =IF(ISBLANK(B10),"",TEXT(B10,"mmm")) "Karen" wrote: 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? |
| Reply |
| 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 | |||
Hybrid Mode
