funciones
DESCRIPTION
dssdsdsdsdTRANSCRIPT
CONSUMO DE ACERO (BARRENOS) EN LABOR "FR-35N"PERFORISTA labor barrenos costo cantidad costo total IGVGADOS NINA, LUISFR1NORTE 3pies S/. 380.00 4 S/. 1,520.00 S/. 273.60GADOS NINA, LUISTAJEO23 5pies S/. 450.00 6 S/. 2,700.00 S/. 486.00TITO MENDEX, JULTAJEO15S 6pies S/. 500.00 2 S/. 1,000.00 S/. 180.00GINEZ IDO, GERM TAJEO23 3pies S/. 380.00 7 S/. 2,660.00 S/. 478.80TITO MENDEX, JULFR1NORTE 5pies S/. 450.00 8 S/. 3,600.00 S/. 648.00GADOS NINA, LUISFR1NORTE 3pies S/. 380.00 9 S/. 3,420.00 S/. 615.60PEREZ ITO, COSIO TAJEO23 5pies S/. 450.00 4 S/. 1,800.00 S/. 324.00GINEZ IDO, GERM TAJEO23 6pies S/. 500.00 5 S/. 2,500.00 S/. 450.00TITO MENDEX, JULTAJEO15S 3pies S/. 380.00 6 S/. 2,280.00 S/. 410.40GADOS NINA, LUISFR1NORTE 6pies S/. 500.00 7 S/. 3,500.00 S/. 630.00GINEZ IDO, GERM TAJEO23 3pies S/. 380.00 10 S/. 3,800.00 S/. 684.00GADOS NINA, LUISTAJEO15S 6pies S/. 500.00 3 S/. 1,500.00 S/. 270.00GADOS NINA, LUISTAJEO15S 6pies S/. 500.00 6 S/. 3,000.00 S/. 540.00
77 S/. 33,280.00contar_celdas sumar_cantidad costo_total
3pies 5 36 136805pies 3 18 81006pies 5 23 11500
13 77 33280ocultar ymostrar filas y columnas:/Inicio/formatocambiar ancho de fila y columna:/seleccionarrangos: crear, rotulo de filas, columnas, eliminar:seleccionar/botondercheliminar rangos: Formulas/administracion de nombres/seleccionar/eliminar
total IGV_R IGV_2 total_2 luisS/. 1,246.40 18.00% S/. 273.60 S/. 1,246.40 1S/. 2,214.00 18.00% S/. 486.00 S/. 2,214.00 2 funcion producto
S/. 820.00 18.00% S/. 180.00 S/. 820.00 3 funcion potenciaS/. 2,181.20 18.00% S/. 478.80 S/. 2,181.20 4 funcion raiz cuadradaS/. 2,952.00 18.00% S/. 648.00 S/. 2,952.00 5 funcion redondearS/. 2,804.40 18.00% S/. 615.60 S/. 2,804.40 6S/. 1,476.00 18.00% S/. 324.00 S/. 1,476.00 7S/. 2,050.00 18.00% S/. 450.00 S/. 2,050.00 8S/. 1,869.60 18.00% S/. 410.40 S/. 1,869.60 9S/. 2,870.00 18.00% S/. 630.00 S/. 2,870.00 10S/. 3,116.00 18.00% S/. 684.00 S/. 3,116.00 11S/. 1,230.00 18.00% S/. 270.00 S/. 1,230.00 12S/. 2,460.00 18.00% S/. 540.00 S/. 2,460.00 13
#VALUE!
6pies
1520152000
351180800038.9871774
S/. 274.00
CONSUMO DE ACERO (BARRENOS) EN LABOR "FR-35N"PERFORISTA labor barrenos costo cantidad costo total IGV totalGADOS NINA, FR1NORTE 3pies 380 4 1000 180 820GADOS NINA, TAJEO23 5pies 450 6 2660 478.8 2181.2TITO MENDEXTAJEO15S 6pies 500 2 3600 648 2952GINEZ IDO, TAJEO23 3pies 380 7 3420 615.6 2804.4TITO MENDEXFR1NORTE 5pies 450 8 1800 324 1476GADOS NINA, FR1NORTE 3pies 380 9 2500 450 2050PEREZ ITO, C TAJEO23 5pies 450 4 2280 410.4 1869.6GINEZ IDO, TAJEO23 6pies 500 5 3500 630 2870TITO MENDEXTAJEO15S 3pies 380 6 3800 684 3116GADOS NINA, FR1NORTE 6pies 500 7 1500 270 1230GINEZ IDO, TAJEO23 3pies 380 10 3000 540 2460GADOS NINA, TAJEO15S 6pies 500 3 2000 39 3923GADOS NINA, TAJEO15S 6pies 500 6 3000 367 3472
77 34060contar_celdasumar_cantidcosto_total
3pies 5 36 137205pies 3 18 67406pies 5 23 13600
13 77 34060ocultar ymostrar filas y columnas:/Inicio/formatocambiar ancho de fila y columna:/seleccionarrangos: crear, rotulo de filas, columnas, eliminar:seleccionar/botonderch 6pieseliminar rangos: Formulas/administracion de nombres/seleccionar/eliminar
NES FUNCIONES ESTADISTICAS LOGICASCONTARSICONTAR.SI(rango,criterio)
SUMARSI=SUMAR.SI(rango,criterio,rango_suma)
FUNCIONES BASICASIGV_R IGV_2 total_2 luis ´=SUMA(rango) =SUMA(E5:E17) =SUMA(seleccionar rango a suma)
0.18 0 820 1 ´=PROMEDIO(rango) 5.9230769230.18 0 2181.2 2 ´=MAX(rango) 100.18 0 2952 3 ´=MIN(rango) 20.18 0 2804.4 4 ´=CONTAR(rango) celdas 130.18 0 1476 5 FUNCIONES MATEMATICAS0.18 0 2050 6 ALEATORIO =ALEATORIO() 0.5190304690.18 0 1869.6 7 50.18 0 2870 8 970.18 0 3116 9 FACTORIAL ´=FACT(numero) 10.18 0 1230 10 10.18 0 2460 11 Err:5020.18 0 2312 12 1200.18 0 2414 13 POTENCIA ´=POTENCIA(numero;potencia)
PRODUCTO =PRODUCTO(num1,num2,…)#VALUE!
RAIZ =RAIZ(numero)
3.14165 REDONDEAR =REDONDEAR(num,pos_decimales)
-10 ABSOLUTO =ABS(numero)
GRADOS =GRADOS(radianes)=RADIANES(grados)
NES FUNCIONES ESTADISTICAS LOGICAS NUMERO ROMANO=NUMERO.ROMANO(num,forma)
535
13680 RESIDUO8100 =RESIDUO(num,divisor)
#NAME?SUMA DE CUADRADOS
=SUMA.CUADRADOS(NUM1,NUM2,NUM3,…)
MATRIZ=MDETERM(matriz)
1 2 3
4 5 67 8 9
MATRIZINVERSA=MINVERSA(matriz)
1 5 110 19 512 7 3
´=SUMA(rango) =SUMA(E5:E17) =SUMA(seleccionar rango a suma)
100000000001.2834258976
1007.210
23.14
3.13
103.1622776602
1803.1415926536
CDXLIXCDVLIVCDILCDILCDIL
101
=SUMA.CUADRADOS(NUM1,NUM2,NUM3,…)2528
9
-4.5036E+15
141.5714285714