})
"=",公式中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.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"})
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.8，20.6，23.0},{ "低体重","正常","超重","肥胖"
})
六年级
备注
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,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.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.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"})