• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

IF(OR

As OR is associative
OR(cond1;cond2;cond3.....;cond127) = OR(OR(cond1;cond2....cond63);OR(cond65;.....;cond127))

Tested on XLS 2003 and sqeezed in 190 conditions
 
If you need that many conditions in your OR() then you really should look at alternative ways to solve your requirements. It's hard to be specific about that without more information.
 
Back
Top