View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers,microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default 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