Try this:

Entered in I42:

=IF(AND(H80,H120,(H160)+(H200)+(H240)+(H280) 1),2000,"")

I'm assuming the data will only be numeric.

--
Biff
Microsoft Excel MVP


"Scott R" wrote in message
...
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!!