Help with logical function

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?
 
B

Bernard Liengme

=AND(A50=0,A51=0,A52=0,A53=0)
OR
=SUMPRODUCT(--(ABS(A50:A53))=0
best wishes
 
J

JMB

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
 
Joined
Nov 9, 2015
Messages
1
Reaction score
0
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top