Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IS(BLANK)
Can I use this function and apply it to a range of cells. I am trying to use
the following formula; =IF(OR(ISBLANK(F18),(F19),(F20),(F21),(F22),(F23), (F24),(F25),(F26),(F27),(F28),(F29)),L47,"") It works if I have a number in cell (F18), but when there is no number in cell (F18), but one in cell (F19) it doesn't work. Can anyone help. Or, is there a better way. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
IS(BLANK)
Hi
do you mean =IF(COUNTA(F18:F29)<12,L47,"") "Jim" wrote: Can I use this function and apply it to a range of cells. I am trying to use the following formula; =IF(OR(ISBLANK(F18),(F19),(F20),(F21),(F22),(F23), (F24),(F25),(F26),(F27),(F28),(F29)),L47,"") It works if I have a number in cell (F18), but when there is no number in cell (F18), but one in cell (F19) it doesn't work. Can anyone help. Or, is there a better way. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
IS(BLANK)
Thanks for the reply.
Clicking on the function button, the formula appears to work, but the cell is blank when the result should be the contents of L47. Why is that? Thanks, Jim "Frank Kabel" wrote: Hi do you mean =IF(COUNTA(F18:F29)<12,L47,"") "Jim" wrote: Can I use this function and apply it to a range of cells. I am trying to use the following formula; =IF(OR(ISBLANK(F18),(F19),(F20),(F21),(F22),(F23), (F24),(F25),(F26),(F27),(F28),(F29)),L47,"") It works if I have a number in cell (F18), but when there is no number in cell (F18), but one in cell (F19) it doesn't work. Can anyone help. Or, is there a better way. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
IS(BLANK)
Frank,
Please disregared our last reply. It's working now. Thanks for your help. Jim & Howard "Frank Kabel" wrote: Hi do you mean =IF(COUNTA(F18:F29)<12,L47,"") "Jim" wrote: Can I use this function and apply it to a range of cells. I am trying to use the following formula; =IF(OR(ISBLANK(F18),(F19),(F20),(F21),(F22),(F23), (F24),(F25),(F26),(F27),(F28),(F29)),L47,"") It works if I have a number in cell (F18), but when there is no number in cell (F18), but one in cell (F19) it doesn't work. Can anyone help. Or, is there a better way. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index/match - make blank cells return a blank value. | Excel Worksheet Functions | |||
Excel 2002: Return blank when VLOOKUP on blank cells | Excel Discussion (Misc queries) | |||
Average Formula to display blank cell if named range is blank | Excel Worksheet Functions | |||
Not showing blank and non blank items in filter mode for values | Excel Worksheet Functions | |||
Copying and pasting a worksheet to a blank and removing blank rows | Excel Programming |