TEMA CONDICIONALES EXCEL
Publicado por maria Chacon (1 intervención) el 15/05/2015 19:31:15
Hola necesito por favor solucionar esta Tarea utilizando las condicionales
Tarea
Países %
Argentina 15%
Brasil 10%
Colombia 30%
Costa Rica 11%
Ecuador 24%
Mexico 25%
Panama 32%
Usa 9%
Venezuela 50%
Se la pagará la comisión de sus ventes en USD
por un % diferente, dependiendo de cada país
Resaltar los resultados
N° APELLIDOS NOMBRES EDAD PESO (KGS) AREA PAISES VENTAS ( COLONES ) VENTAS ( USD ) COMISION
1 Navas Keylor 29 80 Business Support & PM Costa Rica 2.450.000,00 4.553,90
2 Ruiz Bryan 30 76 Finance Colombia 12.000.000,00 22.304,83
3 Campbell Joel 32 98 Finance Venezuela 8.500.000,00 15.799,26
4 Borges Celso 28 76 Day 2 - Support Force Argentina 7.500.000,00 13.940,52
5 Bolaños Christian 23 83 Day 1 - Delivery Force Usa 9.600.000,00 17.843,87
6 Duarte Oscar 24 93 Finance Ecuador 6.055.400,00 11.255,39
7 Tejeda Yeltsin 31 84 Day 1 - Delivery Force Mexico 7.293.902,00 13.557,44
8 Saborio Alvaro 32 78 Business Support & PM Panama 10.350.000,00 19.237,92
9 Gonzalez Giancarlo 33 79 Finance Brasil 39.690.000,00 73.773,23
10 Gamboa Cristian 31 79 Day 0 - Sales Force Venezuela 7.590.400,00 14.108,55
11 Umaña Michael 30 82 Day 1 - Delivery Force Argentina 5.643.902,00 10.490,52
12 Diaz Junior 23 71 General Services Usa 3.450.000,00 6.412,64
13 Miller Roy 24 92 Day 0 - Sales Force Ecuador 13.230.000,00 24.591,08
14 Ureña Marco 26 83 Day 0 - Sales Force Costa Rica 9.960.000,00 18.513,01
15 Oviedo Bryan 28 75 General Management Colombia 9.190.000,00 17.081,78
16 Miguel Jose 29 97 General Services Venezuela 11.520.000,00 21.412,64
17 Brenes Randall 32 75 General Services Argentina 5.350.000,00 9.944,24
18 Calvo Diego 31 82 Finance Usa 3.580.000,00 6.654,28
19 Pemberton Patrick 30 92 General Services Ecuador 7.170.400,00 13.327,88
20 Ramirez David 34 83 Day 2 - Support Force Mexico 8.300.333,00 15.428,13
21 Jairo John 28 77 IT & MIS Panama 10.660.400,00 19.814,87
22 Acosta Johnny 31 78 Day 1 - Delivery Force Brasil 8.943.902,00 16.624,35
23 Hernandez Carlos 25 78 Day 1 - Delivery Force Usa 2.950.000,00 5.483,27
24 Barrantes Michael 24 81 HHRR Ecuador 11.385.000,00 21.161,71
25 Vargas Olman 26 70 Day 0 - Sales Force Costa Rica 9.230.000,00 17.156,13
26 Arrieta Jairo 20 91 Day 2 - Support Force Colombia 6.655.000,00 12.369,89
27 Cunningham Kenny 29 73 Day 0 - Sales Force Venezuela 10.560.000,00 19.628,25
28 Cambronero Daniel 30 94 Day 1 - Delivery Force Argentina 2.125.000,00 3.949,81
29 Mora Heiner 31 85 Day 1 - Delivery Force Usa 2.390.000,00 4.442,38
30 Mcdonald Jonathan 29 77 Business Support & PM Venezuela 3.255.400,00 6.050,93
31 Wallace Rodney 27 99 Day 0 - Sales Force Argentina 6.880.333,00 12.788,72
32 Badilla Gabriel 25 77 Day 0 - Sales Force Usa 6.055.400,00 11.255,39
33 Castillo Mauricio 23 84 Day 2 - Support Force Ecuador 7.293.902,00 13.557,44
34 Lagos Cristhian 29 94 Day 0 - Sales Force Mexico 10.350.000,00 19.237,92
35 Bustos Juan 31 85 Business Support & PM Panama 39.690.000,00 73.773,23
36 Rodriguez Ariel 32 79 Finance Brasil 29.880.000,00 55.539,03
37 Esteban Oscar 29 80 Day 0 - Sales Force Usa 27.570.000,00 51.245,35
38 Myrie Dave 28 80 Day 1 - Delivery Force Ecuador 34.560.000,00 64.237,92
39 Johnson Carlos 27 83 General Services Mexico 16.050.000,00 29.832,71
40 George Mayron 26 72 Day 0 - Sales Force Panama 10.740.000,00 19.962,83
41 Calvo Francisco 21 93 Day 0 - Sales Force Brasil 21.511.200,00 39.983,64
42 Francis Waylon 20 75 General Management Ecuador 24.900.999,00 46.284,38
43 Salazar Pablo 23 96 General Services Mexico 31.981.200,00 59.444,61
44 Salvatierra Jose 22 87 General Services Panama 26.831.706,00 49.873,06
45 Waston Kendall 23 79 Finance Brasil 6.055.400,00 11.255,39
46 Rodriguez Osvaldo 24 91 General Management Venezuela 7.293.902,00 13.557,44
47 Meneses Cristopher 28 79 General Services Argentina 10.350.000,00 19.237,92
48 Alvarado Esteban 19 86 General Services Usa 39.690.000,00 73.773,23
49 Venegas Johan 20 96 Finance Ecuador 6.055.400,00 11.255,39
50 Azofeifa Randall 26 87 General Management Costa Rica 7.293.902,00 13.557,44
51 Moreira Leonel 27 81 General Services Costa Rica 10.350.000,00 19.237,92
Muchas Gracias
Tarea
Países %
Argentina 15%
Brasil 10%
Colombia 30%
Costa Rica 11%
Ecuador 24%
Mexico 25%
Panama 32%
Usa 9%
Venezuela 50%
Se la pagará la comisión de sus ventes en USD
por un % diferente, dependiendo de cada país
Resaltar los resultados
N° APELLIDOS NOMBRES EDAD PESO (KGS) AREA PAISES VENTAS ( COLONES ) VENTAS ( USD ) COMISION
1 Navas Keylor 29 80 Business Support & PM Costa Rica 2.450.000,00 4.553,90
2 Ruiz Bryan 30 76 Finance Colombia 12.000.000,00 22.304,83
3 Campbell Joel 32 98 Finance Venezuela 8.500.000,00 15.799,26
4 Borges Celso 28 76 Day 2 - Support Force Argentina 7.500.000,00 13.940,52
5 Bolaños Christian 23 83 Day 1 - Delivery Force Usa 9.600.000,00 17.843,87
6 Duarte Oscar 24 93 Finance Ecuador 6.055.400,00 11.255,39
7 Tejeda Yeltsin 31 84 Day 1 - Delivery Force Mexico 7.293.902,00 13.557,44
8 Saborio Alvaro 32 78 Business Support & PM Panama 10.350.000,00 19.237,92
9 Gonzalez Giancarlo 33 79 Finance Brasil 39.690.000,00 73.773,23
10 Gamboa Cristian 31 79 Day 0 - Sales Force Venezuela 7.590.400,00 14.108,55
11 Umaña Michael 30 82 Day 1 - Delivery Force Argentina 5.643.902,00 10.490,52
12 Diaz Junior 23 71 General Services Usa 3.450.000,00 6.412,64
13 Miller Roy 24 92 Day 0 - Sales Force Ecuador 13.230.000,00 24.591,08
14 Ureña Marco 26 83 Day 0 - Sales Force Costa Rica 9.960.000,00 18.513,01
15 Oviedo Bryan 28 75 General Management Colombia 9.190.000,00 17.081,78
16 Miguel Jose 29 97 General Services Venezuela 11.520.000,00 21.412,64
17 Brenes Randall 32 75 General Services Argentina 5.350.000,00 9.944,24
18 Calvo Diego 31 82 Finance Usa 3.580.000,00 6.654,28
19 Pemberton Patrick 30 92 General Services Ecuador 7.170.400,00 13.327,88
20 Ramirez David 34 83 Day 2 - Support Force Mexico 8.300.333,00 15.428,13
21 Jairo John 28 77 IT & MIS Panama 10.660.400,00 19.814,87
22 Acosta Johnny 31 78 Day 1 - Delivery Force Brasil 8.943.902,00 16.624,35
23 Hernandez Carlos 25 78 Day 1 - Delivery Force Usa 2.950.000,00 5.483,27
24 Barrantes Michael 24 81 HHRR Ecuador 11.385.000,00 21.161,71
25 Vargas Olman 26 70 Day 0 - Sales Force Costa Rica 9.230.000,00 17.156,13
26 Arrieta Jairo 20 91 Day 2 - Support Force Colombia 6.655.000,00 12.369,89
27 Cunningham Kenny 29 73 Day 0 - Sales Force Venezuela 10.560.000,00 19.628,25
28 Cambronero Daniel 30 94 Day 1 - Delivery Force Argentina 2.125.000,00 3.949,81
29 Mora Heiner 31 85 Day 1 - Delivery Force Usa 2.390.000,00 4.442,38
30 Mcdonald Jonathan 29 77 Business Support & PM Venezuela 3.255.400,00 6.050,93
31 Wallace Rodney 27 99 Day 0 - Sales Force Argentina 6.880.333,00 12.788,72
32 Badilla Gabriel 25 77 Day 0 - Sales Force Usa 6.055.400,00 11.255,39
33 Castillo Mauricio 23 84 Day 2 - Support Force Ecuador 7.293.902,00 13.557,44
34 Lagos Cristhian 29 94 Day 0 - Sales Force Mexico 10.350.000,00 19.237,92
35 Bustos Juan 31 85 Business Support & PM Panama 39.690.000,00 73.773,23
36 Rodriguez Ariel 32 79 Finance Brasil 29.880.000,00 55.539,03
37 Esteban Oscar 29 80 Day 0 - Sales Force Usa 27.570.000,00 51.245,35
38 Myrie Dave 28 80 Day 1 - Delivery Force Ecuador 34.560.000,00 64.237,92
39 Johnson Carlos 27 83 General Services Mexico 16.050.000,00 29.832,71
40 George Mayron 26 72 Day 0 - Sales Force Panama 10.740.000,00 19.962,83
41 Calvo Francisco 21 93 Day 0 - Sales Force Brasil 21.511.200,00 39.983,64
42 Francis Waylon 20 75 General Management Ecuador 24.900.999,00 46.284,38
43 Salazar Pablo 23 96 General Services Mexico 31.981.200,00 59.444,61
44 Salvatierra Jose 22 87 General Services Panama 26.831.706,00 49.873,06
45 Waston Kendall 23 79 Finance Brasil 6.055.400,00 11.255,39
46 Rodriguez Osvaldo 24 91 General Management Venezuela 7.293.902,00 13.557,44
47 Meneses Cristopher 28 79 General Services Argentina 10.350.000,00 19.237,92
48 Alvarado Esteban 19 86 General Services Usa 39.690.000,00 73.773,23
49 Venegas Johan 20 96 Finance Ecuador 6.055.400,00 11.255,39
50 Azofeifa Randall 26 87 General Management Costa Rica 7.293.902,00 13.557,44
51 Moreira Leonel 27 81 General Services Costa Rica 10.350.000,00 19.237,92
Muchas Gracias
Valora esta pregunta
0
