If the value of a group of cells is over a specific amount

[timmtamm]

I just need a simple wording fix that I can't figure out. I have a group of cells, and none of them can be over 20% (.2). If one of these cells are, I need a different cell to recognize that one is bad. I can just do IF and OR statements in the cell I'm using to recognize the problem, but I don't want to have to type out each and every cell in the list.

For example my current solution would have a cell that says: =IF(OR(F10>.2,F11>.2,F12>.2,...(etc)...,F35>.2),"Fail","Pass)

Any suggestions? Thanks.

[tigeravatar]

timmtamm,

For something like this, I would use a CountIf() formula:

=IF(COUNTIF(F10:F35,">0.2")>0,"Fail","Pass")

[timmtamm]

Perfect! Thanks a lot!