formulas básicas Excel

FUNCION	FORMULA	DESCRIPCION
Si	=SI(A2>18,"Edad adecuada","XXXXXXX")	funcion si condicional logica
Si anidada	=SI(C2="Director",1000,SI(C2="Gerente",750,500))
O	=SI(A5=1,"Jueves",SI(A5=2,"Jueves",SI(A5=3,"Miércoles",SI(A5=4,"Miércoles",SI(A5=5,"Lunes",SI(A5=6,"Lunes",SI(A5=7,"Martes",SI(A5=8,"Martes",SI(A5=9,"Viernes",SI(A5=0,"Viernes","Placa invalida"))))))))))
y	=SI(Y(C2="Director",E2>5),1000,SI(Y(C2="Gerente",E2>5),750,SI(Y(C2="Subgerente",E2>5),500,0)))
Si.error	=SI.ERROR(D2/E2,"Falta divisa")
Funcion de texto	=IZQUIERDA(A2,3)
Sumar.si	=SUMAR.SI($B$2:$B$200,E2,$C$2:$C$200)
Contar.si	=CONTAR.SI($B$2:$B$150,E2)
Promedio.si	=PROMEDIO.SI(B2:M2,"<>0")
Sumar.si conjunto	=SUMAR.SI.CONJUNTO($D$2:$D$136,$C$2:$C$136,$F4,$B$2:$B$136,R$3,$A$2:
Cointar.si conjunto	=CONTAR.SI.CONJUNTO($C$2:$C$150,$F4,$B$2:$B$150,AC$3,$A$2:$A$150,$G$1)
min	=MIN(SI(B2:M2<>0,B2:M2))