Hi, I'm trying to insert a function that will calculate the production bonus for my staff. There are several targets that must be met to get the bonus. Just to compound the difficulty the targets can change drop on what product we are running.

I have entered this one so far, which looks at the 3 target numbers.

=IF(AND(OR(I36=0,I36>180),OR(I68=0,I68>60),OR(I100=0,I100>3)),1,0)

If there is no production, target=0, so target is met, and doesn't affect the other parts of the bonus.

if we run Mulch, I36 can drop from >180 to >140. I enter 'Mulch' into I37.

What do I need to include so that this formula looks up the product in I37 and takes this into account.

Thanks