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?

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?

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?

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?