Conditional formula

[olliedstuff]

Hi,

I'm trying to produce a formula for bonus calculation that is driven by monthly and quarterly cumulative performance. I need the formula to calculate the bonus in month one, two and three if target sales are met in the individual months; but if the cumulative performance over the entire quarter deoes not meet the entire quarter target then 0 in each of the three months. I have tried using, IF(OR( formulas but no luck thus far.
Can anyone help please?

Thanks

 

[jasonb75]

In theory

=(month target achieved = yes)*(quarterly target achieved = yes) * bonus

 

[olliedstuff]

Thats looks great. I'll pick it up this afternoon and let you know how I get on. Thanks a lot for your help!

Cheers
Warren.