小学生体质健康测试身高体重评分公式
合集下载
相关主题
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
})
"=",公式中A1指的是身高体重成绩指数。
小学生身高体重指数（BMI）单项评分公
三年级
LOOKUP($A1,{0,13.9,19.5,22.2},{"80","100","80","60"})
LOOKUP($A1,{0,13.9,19.5,22.2},{ "低体重","正常","超重","肥胖"
LOOKUP($A1,{0，14.2，20.2，22.7},{ "低体重","正常","超重","肥胖"
})
LOOKUP($A1,{0,13.7，19.5，22.1},{"80","100","80","60"})
LOOKUP($A1,{0,13.7，19.5，22.1},{ "低体重","正常","超重","肥胖"
LOOKUP($A1,{0,13.7,17.5,20.5},{ "低体重","正常","超重","肥胖"
})
LOOKUP($A1,{0,13.5，17.9,20.3},{"80","100","80","60"})
LOOKUP($A1,{0,13.5,17.9,20.3},{ "低体重","正常","超重","肥胖"
小学生
一年级
LOOKUP($A1,{0,13.5,18.2,20.4},{"80","100","80","60"})
男生
LOOKUP($A1,{0,13.5,18.2,20.4},{"低体重","正常","超重","肥胖"})
LOOKUP($A1,{0,13.3,17.4,19.3},{"80","100","80","60"})
女生
LOOKUP($A1,{0,13.3,17.4,19.3},{"低体重","正常","超重","肥胖"})
说明：在实际应用中要在公式前面输入"=",公式中A1指的是身高体重成绩指数。
小学生身高体重指数（BM
二年级
LOOKUP($A1,{0,13.7,17.5,20.5},{"80","100","80","60"})
})
LOOKUP($A1,{0,13.6,18.7,21.2},{"80","100","80","60"})
LOOKUP($A1,{0,13.6,18.7,21.2},{ "低体重","正常","超重","肥胖"
})
指数（BMI）单项评分公式
四年级
LOOKUP($A1,{0，14.2，20.2，22.7},{"80","100","80","60"})
LOOKUP($A1,{0,13.8，20.6，23.0},{ "低体重","正常","超重","肥胖"
})
六年级
wk.baidu.com备注
LOOKUP($A1,{0,14.7，21.9，24.6},{"80","100","80","60"})
分数
LOOKUP($A1,{0,14.7，21.9，24.6},{ "低体重","正常","超重","肥胖"
})
等级
LOOKUP($A1,{0,14.2，20.9，23.7},{"80","100","80","60"})
分数
LOOKUP($A1,{0,14.2，20.9，23.7},{ "低体重","正常","超重","肥胖"
})
等级
})
评分公式
五年级
LOOKUP($A1,{0,144.4，21.5，24.2},{"80","100","80","60"})
LOOKUP($A1,{0,144.4，21.5，24.2},{ "低体重","正常","超重","肥胖"
})
LOOKUP($A1,{0,13.8，20.6，23.0},{"80","100","80","60"})