Combined IF and OR function

Hi All,

Sorry if this is a silly question but can anyone see a problem with the following?

=IF(OR(SUM(F2:K2)<0.99, 15<L2<30),”Pass”,”Fail”)

F2 to k2 are faults and a 1 is entered in the column if applicable. L2 is a measurement and needs to be between 15 and 30. If no faults are found and a measurement of 15-30 is achieved then the item will pass.

Any help would be greatly appreciated.

Thanks,

Adam

Try this...
=IF(OR(SUM(F2:K2)<0.99,AND(L2>15,L2<30)),"Pass","Fail")

Thanks for the reply,

I am not getting an error anymore, however for some reason i am only retrieving "pass". That would mean the criteria is always coming back as true.

There is no value put in to the cells between F2 and K2. That might cause a problem.

Yes, remember, an OR statement just needs one TRUE to become TRUE. If you have no values from F2:K2, then SUM(F2:K2)<0.99 will always be TRUE.

I reversed the formula so true statements return a FALSE and the criteria was reversed. I applied so conditional formatting and it looks sweet. Thanks for the help

No problem... good to hear that you tweaked it to work... nice work...