Applying Logic

J

Jayvee

need help with logic formulas. i need to write a formula that can be copied
across to determine if all applicants of my research group have invalid
scores. the range of cells (I4:I12) contain true/ false.
 
G

Gary''s Student

Let's assume True means invalid. All invalid means all True.

=AND(I4:I12) will be true only if all are True
 
J

Jayvee

Thanks, I actually came up with that answer 3 seconds before I checked the
response. You just confirmed what I thought was wrong.
 
Top