Applying Logic
 

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.

Applying Logic
 

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

=AND(I4:I12) will be true only if all are True
--
Gary''s Student - gsnu200728


"Jayvee" wrote:

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.

Applying Logic
 

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

"Gary''s Student" wrote:

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

=AND(I4:I12) will be true only if all are True
--
Gary''s Student - gsnu200728


"Jayvee" wrote:

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.