Ventas de vehículos por vendedores | Guías, Proyectos, Investigaciones de Historia de España

Nombre Vendedor ANDREA

Comisión 1260000

Retención 1470000

Valor Neto 45150000

VENDEDOR MARCA COLOR MODELO PRECIO COMISION

JUAN AVEO PLOMO 2007 33,000,000 990,000

DANIELA AVEO ROJO 2009 42,000,000 1,260,000

ANDREA AVEO AZUL 2009 42,000,000 1,260,000

JUAN AVEO PLATA 2009 42,000,000 1,260,000

DANIELA AVEO ROJO 2009 42,000,000 1,260,000

ANDREA AVEO AZUL 2009 42,000,000 1,260,000

DANIELA AVEO PLOMO 2007 33,000,000 990,000

ANDREA AVEO AZUL 2007 33,000,000 990,000

CAMILO AVEO PLATA 2007 33,000,000 990,000

ANDREA AVEO PLATA 2007 33,000,000 990,000

ANDREA AVEO ROJO 2008 36,000,000 1,080,000

CAMILO AVEO PLATA 2008 36,000,000 1,080,000

DANIELA AVEO PLOMO 2009 42,000,000 1,260,000

ANDREA AVEO PLATA 2009 42,000,000 1,260,000

DANIELA AVEO PLOMO 2009 42,000,000 1,260,000

CAMILO BMW ROJO 2005 80,000,000 2,400,000

CAMILO BMW AZUL 2005 80,000,000 2,400,000

JUAN BMW AZUL 2006 85,000,000 2,550,000

DANIELA BMW ROJO 2006 85,000,000 2,550,000

ANDREA BMW PLATA 2007 90,000,000 2,700,000

DANIELA BMW PLATA 2007 90,000,000 2,700,000

ANDREA BMW AZUL 2007 90,000,000 2,700,000

CAMILO BMW PLATA 2008 100,000,000 3,000,000

JUAN BMW ROJO 2009 120,000,000 3,600,000

DANIELA BMW PLATA 2009 115,000,000 3,450,000

JUAN BMW PLATA 2009 120,000,000 3,600,000

JUAN BMW PLOMO 2009 115,000,000 3,450,000

JUAN BMW ROJO 2009 120,000,000 3,600,000

ANDREA RENAULT PLATA 2005 18,000,000 180,000

CAMILO RENAULT ROJO 2005 25,000,000 750,000

ANDREA RENAULT ROJO 2005 17,000,000 170,000

DANIELA RENAULT ROJO 2005 16,000,000 160,000

CAMILO RENAULT PLOMO 2005 21,000,000 630,000

CAMILO RENAULT PLOMO 2005 16,000,000 160,000

JUAN RENAULT ROJO 2006 22,000,000 660,000

ANDREA RENAULT AZUL 2006 20,000,000 200,000

DANIELA RENAULT PLOMO 2006 18,000,000 180,000

JUAN RENAULT PLOMO 2006 20,000,000 200,000

CAMILO RENAULT PLATA 2007 32,000,000 960,000

JUAN RENAULT PLOMO 2007 45,000,000 1,350,000

CAMILO RENAULT PLATA 2008 40,000,000 1,200,000

Valor buscado B1 para buscar por el nombre

Observaciones: Nombrar la matriz o rango con el nombre de VENDEDORES

Utilizar la función si.error

Vista previa parcial del texto

¡Descarga Ventas de vehículos por vendedores y más Guías, Proyectos, Investigaciones en PDF de Historia de España solo en Docsity!

Nombre Vendedor ANDREA

Valor buscado B1 pa Observaciones: Nom

Comisión
Retención
Valor Neto
JUAN AVEO PLOMO 2007 33,000,000 990, VENDEDOR MARCA COLOR MODELO PRECIO COMISION
JUAN AVEO PLOMO 2007 33,000,000 990,
DANIELA AVEO ROJO 2009 42,000,000 1,260,
ANDREA AVEO AZUL 2009 42,000,000 1,260,
JUAN AVEO PLATA 2009 42,000,000 1,260,
DANIELA AVEO ROJO 2009 42,000,000 1,260,
ANDREA AVEO AZUL 2009 42,000,000 1,260,
DANIELA AVEO PLOMO 2007 33,000,000 990,
ANDREA AVEO AZUL 2007 33,000,000 990,
CAMILO AVEO PLATA 2007 33,000,000 990,
ANDREA AVEO PLATA 2007 33,000,000 990,
ANDREA AVEO ROJO 2008 36,000,000 1,080,
CAMILO AVEO PLATA 2008 36,000,000 1,080,
DANIELA AVEO PLOMO 2009 42,000,000 1,260,
ANDREA AVEO PLATA 2009 42,000,000 1,260,
DANIELA AVEO PLOMO 2009 42,000,000 1,260,
CAMILO BMW ROJO 2005 80,000,000 2,400,
CAMILO BMW AZUL 2005 80,000,000 2,400,
JUAN BMW AZUL 2006 85,000,000 2,550,
DANIELA BMW ROJO 2006 85,000,000 2,550,
ANDREA BMW PLATA 2007 90,000,000 2,700,
DANIELA BMW PLATA 2007 90,000,000 2,700,
ANDREA BMW AZUL 2007 90,000,000 2,700,
CAMILO BMW PLATA 2008 100,000,000 3,000,
JUAN BMW ROJO 2009 120,000,000 3,600,
DANIELA BMW PLATA 2009 115,000,000 3,450,
JUAN BMW PLATA 2009 120,000,000 3,600,
JUAN BMW PLOMO 2009 115,000,000 3,450,
JUAN BMW ROJO 2009 120,000,000 3,600,
ANDREA RENAULT PLATA 2005 18,000,000 180,
CAMILO RENAULT ROJO 2005 25,000,000 750,
ANDREA RENAULT ROJO 2005 17,000,000 170,
DANIELA RENAULT ROJO 2005 16,000,000 160,
CAMILO RENAULT PLOMO 2005 21,000,000 630,
CAMILO RENAULT PLOMO 2005 16,000,000 160,
JUAN RENAULT ROJO 2006 22,000,000 660,
ANDREA RENAULT AZUL 2006 20,000,000 200,
DANIELA RENAULT PLOMO 2006 18,000,000 180,
DANIELA RENAULT PLOMO 2006 18,000,000 180,
JUAN RENAULT PLOMO 2006 20,000,000 200,
CAMILO RENAULT PLATA 2007 32,000,000 960,
JUAN RENAULT PLOMO 2007 45,000,000 1,350,
CAMILO RENAULT PLATA 2008 40,000,000 1,200,
CAMILO RENAULT PLATA 2008 32,000,000 960,
CAMILO RENAULT PLATA 2008 20,000,000 200,
DANIELA RENAULT PLOMO 2009 45,000,000 1,350,
ANDREA RENAULT ROJO 2009 42,000,000 1,260,
DANIELA RENAULT ROJO 2009 23,000,000 690,
ANDREA TOYOTA PLOMO 2005 25,000,000 750,
DANIELA TOYOTA PLATA 2005 30,000,000 900,
ANDREA TOYOTA AZUL 2006 20,000,000 200,
CAMILO TOYOTA PLATA 2006 25,000,000 750,
JUAN TOYOTA AZUL 2006 75,000,000 2,250,
JUAN TOYOTA PLATA 2006 22,000,000 660,
JUAN TOYOTA AZUL 2006 95,000,000 2,850,
JUAN TOYOTA PLOMO 2007 26,000,000 780,
ANDREA TOYOTA AZUL 2008 32,000,000 960,
CAMILO TOYOTA ROJO 2008 25,000,000 750,
DANIELA TOYOTA ROJO 2008 20,000,000 200,
JUAN TOYOTA ROJO 2008 45,000,000 1,350,
ANDREA TOYOTA AZUL 2009 50,000,000 1,500,
CAMILO TOYOTA ROJO 2009 65,000,000 1,950,
ANDREA TOYOTA PLATA 2009 95,000,000 2,850,
5,280,000 1,155,000 1,650,000 35,475, IVA RETENCION DESCUENTO VALOR NETO
5,280,000 1,155,000 1,650,000 35,475,
6,720,000 1,470,000 2,100,000 45,150,
6,720,000 1,470,000 2,100,000 45,150,
6,720,000 1,470,000 2,100,000 45,150,
6,720,000 1,470,000 2,100,000 45,150,
6,720,000 1,470,000 2,100,000 45,150,
5,280,000 1,155,000 1,650,000 35,475,
5,280,000 1,155,000 1,650,000 35,475,
5,280,000 1,155,000 1,650,000 35,475,
5,280,000 1,155,000 1,650,000 35,475,
5,760,000 1,260,000 1,800,000 38,700,
5,760,000 1,260,000 1,800,000 38,700,
6,720,000 1,470,000 2,100,000 45,150,
6,720,000 1,470,000 2,100,000 45,150,
6,720,000 1,470,000 2,100,000 45,150,
12,800,000 2,800,000 4,000,000 86,000,
12,800,000 2,800,000 4,000,000 86,000,
13,600,000 2,975,000 4,250,000 91,375,
13,600,000 2,975,000 4,250,000 91,375,
14,400,000 3,150,000 4,500,000 96,750,
14,400,000 3,150,000 4,500,000 96,750,
14,400,000 3,150,000 4,500,000 96,750,
16,000,000 3,500,000 5,000,000 107,500,
19,200,000 4,200,000 6,000,000 129,000,
18,400,000 4,025,000 5,750,000 123,625,
19,200,000 4,200,000 6,000,000 129,000,
18,400,000 4,025,000 5,750,000 123,625,
19,200,000 4,200,000 6,000,000 129,000,
2,880,000 630,000 540,000 19,710,
4,000,000 875,000 1,250,000 26,875,
2,720,000 595,000 510,000 18,615,
2,560,000 560,000 480,000 17,520,
3,360,000 735,000 1,050,000 22,575,
2,560,000 560,000 480,000 17,520,
3,520,000 770,000 1,100,000 23,650,
3,200,000 700,000 600,000 21,900,
2,880,000 630,000 540,000 19,710,
2,880,000 630,000 540,000 19,710,
3,200,000 700,000 600,000 21,900,
5,120,000 1,120,000 1,600,000 34,400,
7,200,000 1,575,000 2,250,000 48,375,
6,400,000 1,400,000 2,000,000 43,000,
5,120,000 1,120,000 1,600,000 34,400,
3,200,000 700,000 600,000 21,900,
7,200,000 1,575,000 2,250,000 48,375,
6,720,000 1,470,000 2,100,000 45,150,
3,680,000 805,000 1,150,000 24,725,
4,000,000 875,000 1,250,000 26,875,
4,800,000 1,050,000 1,500,000 32,250,
3,200,000 700,000 600,000 21,900,
4,000,000 875,000 1,250,000 26,875,
12,000,000 2,625,000 3,750,000 80,625,
3,520,000 770,000 1,100,000 23,650,
15,200,000 3,325,000 4,750,000 102,125,
4,160,000 910,000 1,300,000 27,950,
5,120,000 1,120,000 1,600,000 34,400,
4,000,000 875,000 1,250,000 26,875,
3,200,000 700,000 600,000 21,900,
7,200,000 1,575,000 2,250,000 48,375,
8,000,000 1,750,000 2,500,000 53,750,
10,400,000 2,275,000 3,250,000 69,875,
15,200,000 3,325,000 4,750,000 102,125,

Ventas de vehículos por vendedores, Guías, Proyectos, Investigaciones de Historia de España

Documentos relacionados

Vista previa parcial del texto

¡Descarga Ventas de vehículos por vendedores y más Guías, Proyectos, Investigaciones en PDF de Historia de España solo en Docsity!

Nombre Vendedor ANDREA