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.

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.

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.

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.