If (condition1) AND (either condition 2 3 or 4)

[jbird123]

Hi, looking for some help.

At the moment I have the following formula

=IF((AND(I5>0,J5>0)),1,)

This is ok, if I5 and J5 are both bigger than 0 then display '1'. However I now need to add to that statement 'AND (IF EITHER L15, L16 or L17 > 0)'.

Its quite hard to explain in text, not sure if this makes any sense so see attached XLS.

I dont think it should be difficult, just getting the syntax right and I dont use excel much any more