Help with logical function

  • Thread starter Thread starter PT
  • Start date Start date
P

PT

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?
 
my two cents - as long as the data in the target cells are numeric and not
text.
=--NOT(OR(A50:A53))

Bernard Liengme said:
=AND(A50=0,A51=0,A52=0,A53=0)
OR
=SUMPRODUCT(--(ABS(A50:A53))=0
best wishes
Click to expand...
 
Can I have some help with the same sort of thing please:

I want to look at the value between two cells X and Y, if the value is less than 25 I want to show an "A", if the value is greater than 25 but less than 50 I want it show "B" and if the value if greater than 50 I want it to show "B".

Can someone help?
 
Back
Top