16/Sep/05 18:49
Condicion : =SI(O(27-Veces
Condicion ---SI(O( 27 Veces..
Letras----------No.de Letra
--g-------------( Formula )= 7
--ñ-------------( Formula )= 15
--z-------------( Formula )= 27
--3-------------( Formula )= “error – escriba letras”
'=SI(O(A2="a",A2="b",A2="c",A2="d",A2="e",A2="f"),SI(A2="a",1,SI(A2="b",2,SI(A2="c",3,SI(A2="d",4,SI(A2="e",5,6))))),SI(O(A2="g",A2="h",A2="i",A2="j",A2="k",A2="l"),SI(A2="g",7,SI(A2="h",8,SI(A2="i",9,SI(A2="j",10,SI(A2="k",11,12))))),SI(O(A2="m",A2="n",A2="ñ",A2="o",A2="p",A2="q"),SI(A2="m",13,SI(A2="n",14,SI(A2="ñ",15,SI(A2="o",16,SI(A2="p",17,18))))),SI(O(A2="r",A2="s",A2="t",A2="u",A2="v"),SI(A2="r",19,SI(A2="s",20,SI(A2="t",21,SI(A2="u",22,23)))),SI(A2="w",24,SI(A2="x",25,SI(A2="y",26,SI(A2="z",27,"error - escriba letras"))))))))
Esperando les sea de utilidad..
Saludos..
Jose Luis Padilla
La sonrisa cuesta menos que la electricidad y da más luz.
Desde...Tijuana, B.C.