IS(BLANK)

G

Guest

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.
 
G

Guest

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
 
G

Guest

Frank,
Please disregared our last reply. It's working now. Thanks for your help.

Jim & Howard
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

is there a simpler way to do this formula? 5
Adding formulas 4
Formula error, don't understand why... 2
Excel query help with union select 2
Too many fields for Excel 8
Copy sheet and rename tab 4
Streamlining a long IF=(AND formula ?? 2
=IF logical test to search only part of a cell 2

Top