| NUM |
NOMBRE |
EDAD |
SEXO |
PESO ACTUAL |
ESTATURA |
PESO IDEAL |
DIAGNOSTICO |
| 1 |
ALAMILLA DE LOS SANTOS LAZARO |
17 |
M |
68 |
1.75 |
=SI(D2="M";(F2*100-40)/2;SI(D2="F";(F2*100-45)/2;"ERROR")) |
=SI(E2>G2;"OBESO";SI(E2<G2;"DESNUTRIDO";"FELICIDADES")) |
| 2 |
ALEJANDRO ARIAS CLAUDIA ISBEL |
18 |
F |
66,5 |
1.78 |
=SI(D3="M";(F3*100-40)/2;SI(D3="F";(F3*100-45)/2;"ERROR")) |
=SI(E3>G3;"OBESO";SI(E3<G3;"DESNUTRIDO";"FELICIDADES")) |
| 3 |
ALEJANDRO HERNANDEZ JOSE JOEL |
18 |
M |
70 |
1.6 |
=SI(D4="M";(F4*100-40)/2;SI(D4="F";(F4*100-45)/2;"ERROR")) |
=SI(E4>G4;"OBESO";SI(E4<G4;"DESNUTRIDO";"FELICIDADES")) |
| 4 |
ALEJANDRO PEREZ ELIAS |
19 |
M |
45 |
1.78 |
=SI(D5="M";(F5*100-40)/2;SI(D5="F";(F5*100-45)/2;"ERROR")) |
=SI(E5>G5;"OBESO";SI(E5<G5;"DESNUTRIDO";"FELICIDADES")) |
| 5 |
ALEJANDRO SHIRMA FABIAN |
18 |
M |
75 |
1.67 |
=SI(D6="M";(F6*100-40)/2;SI(D6="F";(F6*100-45)/2;"ERROR")) |
=SI(E6>G6;"OBESO";SI(E6<G6;"DESNUTRIDO";"FELICIDADES")) |
| 6 |
ALEJANDRO VALENZUELA VICTOR MANUEL |
19 |
M |
69 |
1.78 |
=SI(D7="M";(F7*100-40)/2;SI(D7="F";(F7*100-45)/2;"ERROR")) |
=SI(E7>G7;"OBESO";SI(E7<G7;"DESNUTRIDO";"FELICIDADES")) |
| 7 |
AREVALO CORDOVA EMMANUEL |
18 |
M |
78 |
1.89 |
=SI(D8="M";(F8*100-40)/2;SI(D8="F";(F8*100-45)/2;"ERROR")) |
=SI(E8>G8;"OBESO";SI(E8<G8;"DESNUTRIDO";"FELICIDADES")) |
| 8 |
AVALOS MADRIGAL JULIO ADRIAN |
19 |
M |
90 |
1.9 |
=SI(D9="M";(F9*100-40)/2;SI(D9="F";(F9*100-45)/2;"ERROR")) |
=SI(E9>G9;"OBESO";SI(E9<G9;"DESNUTRIDO";"FELICIDADES")) |
| 9 |
BAUTISTA GOMEZ EUNICE |
19 |
F |
59 |
1.67 |
=SI(D10="M";(F10*100-40)/2;SI(D10="F";(F10*100-45)/2;"ERROR")) |
=SI(E10>G10;"OBESO";SI(E10<G10;"DESNUTRIDO";"FELICIDADES")) |
| 10 |
CANCINO VELAZQUEZ GERARDO |
18 |
M |
68 |
1.68 |
=SI(D11="M";(F11*100-40)/2;SI(D11="F";(F11*100-45)/2;"ERROR")) |
=SI(E11>G11;"OBESO";SI(E11<G11;"DESNUTRIDO";"FELICIDADES")) |
| |
|
|
|
|
|
|
|
| |
Cuantos Son Hombres |
=CONTAR.SI(D2:D11;"M") |
|
|
|
|
|
| |
Cuantos Son Mujeres |
=CONTAR.SI(D2:D11;"F") |
|
|
|
|
|
| |
Cuantos Son Mayores de Edad |
=CONTAR.SI(C2:C11;">=18") |
|
|
|
|
|
| |
Cuantos Son Menores de Edad |
=CONTAR.SI(C2:C11;"<18") |
|
|
|
|
|
