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!!

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!!

Thanks heaps for that - it worked great!!

"Scott R" wrote:

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!!

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Scott R" wrote in message
...
Thanks heaps for that - it worked great!!

"Scott R" wrote:

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!!