Applying Logic

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Let's assume True means invalid. All invalid means all True.

=AND(I4:I12) will be true only if all are True
 
Thanks, I actually came up with that answer 3 seconds before I checked the
response. You just confirmed what I thought was wrong.
 

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

Similar Threads

Determining Quantity and Keeping a Constant 4
help 2
SUMIF? 9
Excel VBA 1
Displaing result in Entire worksheet 4
Excel Vlookup Help 0
Average of logic cells 2
HOW TO APPLY GRAY HIGHLIGHTING TO RANGE, BASED ON ENTRY IN ONE CELL 4

Back
Top