IF FALSE anywhere in range
 

I want to put an IF function in a conditional format that activates if
anywhere in range AG13:AG53 there is the result FALSE. Any suggestions?

--
David P.

IF FALSE anywhere in range
 

Don't need an IF

Say Formula is:

=AG13*AG14*AG15*AG16*AG17*AG18*AG19*AG20*AG21*AG22 *AG23*AG24*AG25*AG26*AG27*AG28*AG29*AG30*AG31*AG32 *AG33*AG34*AG35*AG36*AG37*AG38*AG39*AG40*AG41*AG42 *AG43*AG44*AG45*AG46*AG47*AG48*AG49*AG50*AG51*AG52 *AG53=0

because if any value is FALSE the product is zero.

--
Gary''s Student - gsnu200793


"David P." wrote:

I want to put an IF function in a conditional format that activates if
anywhere in range AG13:AG53 there is the result FALSE. Any suggestions?

--
David P.

IF FALSE anywhere in range
 

Perhaps

=NOT(AND(AG13:AG53))

"David P." wrote:

I want to put an IF function in a conditional format that activates if
anywhere in range AG13:AG53 there is the result FALSE. Any suggestions?

--
David P.

IF FALSE anywhere in range
 

Another:

=countif(ag13:ag53,false)0
or
=if(countif(ag13:ag53,false)0,"at least one false","no falses")


David P. wrote:

I want to put an IF function in a conditional format that activates if
anywhere in range AG13:AG53 there is the result FALSE. Any suggestions?

--
David P.

--

Dave Peterson