Thread: Return null
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Karen Karen is offline
external usenet poster
 
Posts: 447
Default 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?