multiple or conditions

[lschuh]

I have written syntax that doesn't seem to be picking up all my or conditions
thus leaving me with an inaccurate answer. What am I doing wrong?

=IF($I5>2.5,1,0)*OR($K5>2.5,1,0)*OR($M5>2.5,1,0)*OR($O5>2.5,1,0)
*OR($Q5>2.5,1,0)*OR($J5>5,1,0)*OR($L5>5,1,0)*OR($N5>5,1,0)
*OR($P5>5,1,0)*OR($R5>5,1,0)

 

[Don Guillett]

Look in HELP index for the proper syntax for OR

 

[bj]

try instead
=if(or($I5>2.5,$K5>2.5,$M5>2.5,$O5>2.5,$Q5>2.5,$J5>5,$L5>5,$N5>5,$P5>5,$R5>5),1,0)
Your logic was fine, just the format of how to use the or was off. (If I
thought about it, I could probably guess what Your spread sheet background is)

 

[Bob Phillips]

The format is

=IF(OR(condition1, condition2, condition3, ...), action1, action2)