| Table de recherches multiples | ||||||||||
|
Vendeur
|
Années
|
Ventes
|
Taux de commission
|
Commission
|
Moins de 3 ans | Plus de 3 ans | ||||
| Sandra | 2 | 120'000 | 7.00% | 8'400 | Montant | Taux | Montant | Taux | ||
| Éric | 1 | 210'921 | 7.00% | 14'764 | 0 | 1.50% | 0 | 2.00% | ||
| Laurent | 1 | 100'000 | 7.00% | 7'000 | 5'000 | 3.25% | 50'000 | 6.25% | ||
| Valérie | 2 | 87'401 | 6.00% | 5'244 | 10'000 | 3.50% | 100'000 | 7.25% | ||
| Sophie | 6 | 310'983 | 9.25% | 28'766 | 20'000 | 5.00% | 200'000 | 8.25% | ||
| Audrey | 3 | 43'902 | 2.00% | 878 | 50'000 | 6.00% | 300'000 | 9.25% | ||
| Maxime | 2 | 121'021 | 7.00% | 8'471 | 100'000 | 7.00% | 500'000 | 10.00% | ||
| Marie-Laure | 3 | 908 | 2.00% | 18 | 250'000 | 8.00% | ||||
| Franck | 1 | 0 | 1.50% | 0 | ||||||
| Aurélien | 4 | 359'832 | 9.25% | 33'284 | ||||||
| Simon | 4 | 502'983 | 10.00% | 50'298 | ||||||
| =RECHERCHEV(C4;SI(B4<3;Table1;Table2);2) | ||||||||||