OR cell range

A

ArtySin

Hi,
I have a formula that works fine to produce a result of either Pass or Fail
in a cell. This formula looks at 4 cells thus:
=IF(OR(J133="Fail",J134="Fail",J135="Fail",J136="Fail"),"Fail","Pass")
I now have a requirement where this will cover more than 20 cells in a
column and rather than write a condition for each cell is there some other
way to do this. I tried naming a range of cells but that doesn't work.
Many thanks
 

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

OR statement with range of cells 5
How to give count of lines before all 5 values pass?? 18
Calculate a Tolerance 4
IF formula can't figure out, please help 4
help with a IF formula 9
Cumulative formula for word table 0
excel percent using countif 1
Determining latest entry in Row of values and extracting value 4

Top