=IF(AND(O7<2.5,((Q7>22)*OR(Q7<35.2,))*U7>0),1,0)
This seems to work but it was a solution offered by excel itself. I don't understand how it works. Can someone explain please?

Thanks
Twodogs