| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF ISBLANK Function
Hi,
It is possible to use If ISBLANK to find a blank cell lest say Y39 and if it is blank inout the text Month Unknown into the cell? If so please tell me what is the syntax as I ahve tried and no luck...if not can you offer an alternative? Thank you |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF ISBLANK Function
Do you mean
=IF(Y39="","Month Unknown","") 'If you have date in Y39 =IF(Y39,TEXT(Y39,"mmmm"),"Month Unknown") If this post helps click Yes --------------- Jacob Skaria "TDMP" wrote: Hi, It is possible to use If ISBLANK to find a blank cell lest say Y39 and if it is blank inout the text Month Unknown into the cell? If so please tell me what is the syntax as I ahve tried and no luck...if not can you offer an alternative? Thank you |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF ISBLANK Function
If you have a formula returning a blank "" then ISBLANK will not identify
that as a blank cell.. =IF(ISBLANK(Y39),"Month Unknown","") If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Do you mean =IF(Y39="","Month Unknown","") 'If you have date in Y39 =IF(Y39,TEXT(Y39,"mmmm"),"Month Unknown") If this post helps click Yes --------------- Jacob Skaria "TDMP" wrote: Hi, It is possible to use If ISBLANK to find a blank cell lest say Y39 and if it is blank inout the text Month Unknown into the cell? If so please tell me what is the syntax as I ahve tried and no luck...if not can you offer an alternative? Thank you |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF ISBLANK Function
Hi Jacob,
Just so I am clear...I have cells that have months based on a date but some of the dates are blank hence no month will show...I want to be able to put the words Month Unknown into the blank cells so when I chart by month those blanks will say Month Unknown "Jacob Skaria" wrote: Do you mean =IF(Y39="","Month Unknown","") 'If you have date in Y39 =IF(Y39,TEXT(Y39,"mmmm"),"Month Unknown") If this post helps click Yes --------------- Jacob Skaria "TDMP" wrote: Hi, It is possible to use If ISBLANK to find a blank cell lest say Y39 and if it is blank inout the text Month Unknown into the cell? If so please tell me what is the syntax as I ahve tried and no luck...if not can you offer an alternative? Thank you |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF ISBLANK Function
Select the column. Press function key F5.Click 'Special'check 'Blanks' and
hit OK.. This will select all blank cells in the range..Keeping the selection type 'Month Unknow' and hit Ctrl+Enter.. If these cells have formulas then modify the formula to return 'Month blank' if a month cannot be returned If this post helps click Yes --------------- Jacob Skaria "TDMP" wrote: Hi Jacob, Just so I am clear...I have cells that have months based on a date but some of the dates are blank hence no month will show...I want to be able to put the words Month Unknown into the blank cells so when I chart by month those blanks will say Month Unknown "Jacob Skaria" wrote: Do you mean =IF(Y39="","Month Unknown","") 'If you have date in Y39 =IF(Y39,TEXT(Y39,"mmmm"),"Month Unknown") If this post helps click Yes --------------- Jacob Skaria "TDMP" wrote: Hi, It is possible to use If ISBLANK to find a blank cell lest say Y39 and if it is blank inout the text Month Unknown into the cell? If so please tell me what is the syntax as I ahve tried and no luck...if not can you offer an alternative? Thank you |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF ISBLANK Function
Hmm...I can do that but im looking for an automatic method since the data
sheet will be constantly updated..so I need a formula that will always look for blanks and then write the text in the cells if it finds a blank cell.. "Jacob Skaria" wrote: Select the column. Press function key F5.Click 'Special'check 'Blanks' and hit OK.. This will select all blank cells in the range..Keeping the selection type 'Month Unknow' and hit Ctrl+Enter.. If these cells have formulas then modify the formula to return 'Month blank' if a month cannot be returned If this post helps click Yes --------------- Jacob Skaria "TDMP" wrote: Hi Jacob, Just so I am clear...I have cells that have months based on a date but some of the dates are blank hence no month will show...I want to be able to put the words Month Unknown into the blank cells so when I chart by month those blanks will say Month Unknown "Jacob Skaria" wrote: Do you mean =IF(Y39="","Month Unknown","") 'If you have date in Y39 =IF(Y39,TEXT(Y39,"mmmm"),"Month Unknown") If this post helps click Yes --------------- Jacob Skaria "TDMP" wrote: Hi, It is possible to use If ISBLANK to find a blank cell lest say Y39 and if it is blank inout the text Month Unknown into the cell? If so please tell me what is the syntax as I ahve tried and no luck...if not can you offer an alternative? Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ISBLANK function not working when cell is blank dut to function re | Excel Discussion (Misc queries) | |||
| ISBLANK and OR Function | Excel Worksheet Functions | |||
| IF Function with ISBLANK | Excel Worksheet Functions | |||
| ISBLANK FUNCTION | Excel Worksheet Functions | |||
| ISBLANK function??? | Excel Worksheet Functions | |||
Linear Mode
