Help with logical function
 

I want to use a conditional formatting statement on a cell to be true if
four other conditions are true.

I set the conditional formatting to apply if the value of the test cell = 1

Then I'd like to set an IF statement to produce a value 1 for that cell if
the four conditions are all true.

Thus, for example, if cells A50, A51. A52 and A53 are all zero the
conditional format test cell also is true (i.e., has a value of 1).

So what is the correct Boolean statement for the test cell?
--

PT

Help with logical function
 

=AND(A50=0,A51=0,A52=0,A53=0)
OR
=SUMPRODUCT(--(ABS(A50:A53))=0
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"PT" wrote in message
...
I want to use a conditional formatting statement on a cell to be true if
four other conditions are true.

I set the conditional formatting to apply if the value of the test cell =
1

Then I'd like to set an IF statement to produce a value 1 for that cell if
the four conditions are all true.

Thus, for example, if cells A50, A51. A52 and A53 are all zero the
conditional format test cell also is true (i.e., has a value of 1).

So what is the correct Boolean statement for the test cell?
--

PT

Help with logical function
 

my two cents - as long as the data in the target cells are numeric and not
text.
=--NOT(OR(A50:A53))

"Bernard Liengme" wrote:

=AND(A50=0,A51=0,A52=0,A53=0)
OR
=SUMPRODUCT(--(ABS(A50:A53))=0
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"PT" wrote in message
...
I want to use a conditional formatting statement on a cell to be true if
four other conditions are true.

I set the conditional formatting to apply if the value of the test cell =
1

Then I'd like to set an IF statement to produce a value 1 for that cell if
the four conditions are all true.

Thus, for example, if cells A50, A51. A52 and A53 are all zero the
conditional format test cell also is true (i.e., has a value of 1).

So what is the correct Boolean statement for the test cell?
--

PT