Last active
October 19, 2022 22:35
-
-
Save ernestoruiz89/22ebf6938ae6e4afb68e9930ee387f76 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
//Para sumar un rango dinamicamente tomando en cuenta la fecha de analisis con encabezados de fecha | |
=SUMA(INDIRECTO("F"&FILA()&"C2:F"&FILA()&"C"&COINCIDIR(BUSCARH($L$2,$4:$4,1,1),$4:$4,0),FALSO)) | |
//Validar letra de cédula Nicaragüense | |
= SI(B2<>"", | |
SI(LARGO(B2)=14, | |
SI( IGUAL( | |
CONCATENAR( | |
EXTRAE(B2,1,13), | |
EXTRAE("ABCDEFGHJKLMNPQRSTUVWXY", ( EXTRAE(B2,1,13)-MULTIPLO.INFERIOR.MAT(EXTRAE(B2,1,13)/23)*23 )+1,1 ) | |
),MAYUSC(B2)),"ü","û"),"û"),"") |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment