Need a formula...
attached sheet clear example for country-wise payout working
Note : criteria in the below example sheet
| Mobile & Accessories Group conditions | | | | | | | | | | | | | | | |
| | 1 | On total fulfilment is more than 100% as well as Accessories group also more than 100% the Total payout will be calculated by 0.5% | | | | |
| | 2 | IF 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..
