Range

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

alex - 07 Mar 2008 12:07 GMT

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

Reply to this Message

Ron Coderre - 07 Mar 2008 12:24 GMT

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)

> Hello experts,
>
[quoted text clipped - 16 lines]
> thoughts?
> alex

Reply to this Message

alex - 07 Mar 2008 18:24 GMT

On Mar 7, 7:24 am, "Ron Coderre" <ronREMOVETHIScode...@bigfoot.com>
wrote:

> If the B1:B55 range cells will either contain a value
> OR be truly blank (containing nothing....not even a formula)
[quoted text clipped - 33 lines]
>
> - 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

Reply to this Message