| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Either showing : empty or blank
My nice working formula is :
=text(A1,"mmmm") It gives me the name of the month(in B) depending on the date in A When A is blank then it gives 'January' in B. WONDERING if the result in B can be either nothing(blank) or the word "empty" when A is blank or have no values. If somebody knows both ways, I'll be gratefull to learn it. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formulas showing up in an empty cell by themselves | Excel Discussion (Misc queries) | |||
| Avoiding empty cells showing as zero in line chart without na() | Charts and Charting in Excel | |||
| Not showing blank and non blank items in filter mode for values | Excel Worksheet Functions | |||
| How can I chart a data series without showing empty cells? | Charts and Charting in Excel | |||
| showing blank cells | Excel Discussion (Misc queries) | |||
Threaded Mode
