country-wise bonus cal

Highlighted
Regular Visitor

Need a formula...

 

attached sheet clear example for country-wise payout working

Note : criteria in the below example sheet

Mobile & Accessories Group conditions               
 1On total fulfilment is more than 100% as well as Accessories group also more than 100% the Total payout will be calculated by 0.5%    
 2IF Total Fulfilment is more than 100% and Accessories group is less than100% then total payout will calculated by each group i.e. mobiles@0.3% & Asscessories@ 0.5%

formula to be required in only one cell

the formula for each qtr type in  T5, U5, V5, W5.

 

Thanks in advance...

Awaiting a positive reply..

0 Replies