Hello experts,

using Excel '03...

I'm trying to write a formula that checks a range of cells, basically
modifying this formula:

if(B55="","1","2")

to something like this:

if(isblank(B1:B55),"1","2") meaning if ANY cell from B1 to B55 has a
value, return "2"

This formula only seems to work on an adjacent cell; i.e., when I type
the formula in A13 and B13 possesses a value, else this formula
returns a "1"

thoughts?
alex