| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Either showing : empty or blank
hi
try =if(A1="","",Text(A1,"mmmm")) or =if(A1="","Empty",Text(A1,"mmmm")) Regards FSt1 "Wonderer" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Either showing : empty or blank
Hi,
With your formula =IF(A1,text(A1,"mmmm"),"") This assumes A1 is blank if not use =IF(ISNUMBER(A1),text(A1,"mmmm"),"") If this helps, please click the Yes button. -- Thanks, Shane Devenshire "Wonderer" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Either showing : empty or blank
Thanks twice. Wonderfull
"FSt1" wrote: hi try =if(A1="","",Text(A1,"mmmm")) or =if(A1="","Empty",Text(A1,"mmmm")) Regards FSt1 "Wonderer" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Either showing : empty or blank
THANK YOU! Wow
"ShaneDevenshire" wrote: Hi, With your formula =IF(A1,text(A1,"mmmm"),"") This assumes A1 is blank if not use =IF(ISNUMBER(A1),text(A1,"mmmm"),"") If this helps, please click the Yes button. -- Thanks, Shane Devenshire "Wonderer" wrote: 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 |
| Reply |
| 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) | |||
Linear Mode
