The Formula:

=IF(AND(ISNUMBER(SEARCH({"PRO","NOP","VAL"},B55)), OR(H55524,AND(I551568,I55<3238),AND(J554883,
J55<9077),AND(K55861,K55<1674))),10,0)


I am trying to achieve the following logic:

If B55 includes PRO NOP or VAL and either H55524, 1568<I55<3238,
4883<J55<9077 or 861<K55<1674 then return the value 10, if not return
0. But the above formula always appears to return 0 and I was unseure
about the multiple AND & OR statements.

Any help would be gratefully recieved.

Regards

Jamie