IF formula help..

[Scott R]

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

 

[T. Valko]

Try this:

Entered in I42:

=IF(AND(H8>0,H12>0,(H16>0)+(H20>0)+(H24>0)+(H28>0)>1),2000,"")

I'm assuming the data will only be numeric.

 

[Scott R]

Thanks heaps for that - it worked great!!

 

[T. Valko]

You're welcome. Thanks for the feedback!