Warning text triggered by values of a cell range
 

I'm doing something wrong and can't figure it out. Can anybody help me?

Heres what I want: If user enter value in cells A1 through A5, I want cell
A6 to return €œMust be filled in€�

Heres the formula I put in A6: =IF(A10,"Must be filled in!","") and it
works, but only for one reference cell.

What I want is a range of cells (A1:A5). So I enter in A6: =IF(A1:A50,"Must
be filled in!",""). And I get a #VALUE! Error in A6.

Help!
--
Merci!
Bonzai

Warning text triggered by values of a cell range
 

=if(count(a1:a5)=5,"Must be filled in","")
if you enter numbers in a1:a5

=if(counta(a1:a5)=5,"Must be filled in","")
if you enter numbers or text in A1:A5

I would put the formula in B6, though and use a formula like:
=if(and(count(a1:a5)=5,a6=""),"A6 Must be filled in","")

Bonzai wrote:

I'm doing something wrong and can't figure it out. Can anybody help me?

Heres what I want: If user enter value in cells A1 through A5, I want cell
A6 to return €œMust be filled in€�

Heres the formula I put in A6: =IF(A10,"Must be filled in!","") and it
works, but only for one reference cell.

What I want is a range of cells (A1:A5). So I enter in A6: =IF(A1:A50,"Must
be filled in!",""). And I get a #VALUE! Error in A6.

Help!
--
Merci!
Bonzai

--

Dave Peterson

Warning text triggered by values of a cell range
 

It works! Thank You Dave for taking the time to help me, I appreciate it!
Merci Beaucoup!
--
Bonzai

"Dave Peterson" wrote:

=if(count(a1:a5)=5,"Must be filled in","")
if you enter numbers in a1:a5

=if(counta(a1:a5)=5,"Must be filled in","")
if you enter numbers or text in A1:A5

I would put the formula in B6, though and use a formula like:
=if(and(count(a1:a5)=5,a6=""),"A6 Must be filled in","")

Bonzai wrote:

I'm doing something wrong and can't figure it out. Can anybody help me?

Here's what I want: If user enter value in cells A1 through A5, I want cell
A6 to return "Must be filled in"

Here's the formula I put in A6: =IF(A10,"Must be filled in!","") and it
works, but only for one reference cell.

What I want is a range of cells (A1:A5). So I enter in A6: =IF(A1:A50,"Must
be filled in!",""). And I get a #VALUE! Error in A6.

Help!
--
Merci!
Bonzai

--

Dave Peterson

Warning text triggered by values of a cell range
 

Da Nada

Bonzai wrote:

It works! Thank You Dave for taking the time to help me, I appreciate it!
Merci Beaucoup!
--
Bonzai

"Dave Peterson" wrote:

=if(count(a1:a5)=5,"Must be filled in","")
if you enter numbers in a1:a5

=if(counta(a1:a5)=5,"Must be filled in","")
if you enter numbers or text in A1:A5

I would put the formula in B6, though and use a formula like:
=if(and(count(a1:a5)=5,a6=""),"A6 Must be filled in","")

Bonzai wrote:

I'm doing something wrong and can't figure it out. Can anybody help me?

Here's what I want: If user enter value in cells A1 through A5, I want cell
A6 to return "Must be filled in"

Here's the formula I put in A6: =IF(A10,"Must be filled in!","") and it
works, but only for one reference cell.

What I want is a range of cells (A1:A5). So I enter in A6: =IF(A1:A50,"Must
be filled in!",""). And I get a #VALUE! Error in A6.

Help!
--
Merci!
Bonzai

--

Dave Peterson


--

Dave Peterson