A ahhhmed Member Apr 3, 2014 #1 The =IF(OR ... formula accepts only 64 threads. Is there any way to double that number?
iferror Member Apr 3, 2014 #2 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
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
Colin Legg Active Member Apr 3, 2014 #3 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.
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.