Hi there im creating a commissions template and need a formula that will do
the following;

If H8 and H12 are both greater than zero AND at least 2 of the following 4
cells are greater than zero (H16, H20, H24 & H28) then put $2000 in I42.

Any help would be great!!