Thread: IS(BLANK)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Jim is offline
external usenet poster
 
Posts: 615
Default 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.