Range

[alex]

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

 

[Ron Coderre]

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]

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)











- 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