Range

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

If the B1:B55 range cells will either contain a value
OR be truly blank (containing nothing....not even a formula)
try this:
=IF(COUNTA(B1:B55),"2","1")

Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"alex" wrote in message
...
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

On Mar 7, 7:24*am, "Ron Coderre"
wrote:
If the B1:B55 range cells will either contain a value
OR be truly blank (containing nothing....not even a formula)
try this:
=IF(COUNTA(B1:B55),"2","1")

Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"alex" wrote in message

...



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- Hide quoted text -

- Show quoted text -

Thanks Ron for your reply.
I'll try to work with this, but I believe the cells (B1:B55) will have
formulas in them.

alex