multiple or conditions

G

Guest

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)
 
G

Guest

Syntax is =IF(OR(condition1,condition2,condition3,...),value if true,value if
false)
-- that is, only ONE "OR" would be in the formula. Not sure what you're
trying to accomplish here.
 

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

Top