Using ISBLANK on a range of cells

[shanec7401]

Hi

I want my formula to check a range of cells (D111:D132) in a separate worksheet called Graphs and if these are blank to return no value.
I tried the following but it didnt work (the last section is just simple division)

=IF(Graphs!(ISBLANK(D111:D132)),"",Graphs!D104/Graphs!D105)

I am obviously doing something wrong here.
Anyone can help me?

 

[VoG]

Try

=IF(COUNTBLANK(Graphs!D111:D132)=22,"",Graphs!D104/Graphs!D105)

 

[Richard Schollar]

If you want to restrict if all blank cells:

=IF(COUNTA(Graphs!D111:D132)=0,"",Graphs!D104/Graphs!D105)

But this does depend on what you have in D111:D132 and what you mean by blanks - if the blank is the result of a formula (ie ="") then COUNTA won't work.

 

[shanec7401]

yeah Richard, it is based on a formula but VoG's works.
This site rocks

cheers guys