电子表格自动查询2014新修订小学男女生体重指数(BMI)评分表函数
来源:学生作业帮 编辑:百度作业网作业帮 分类:综合作业 时间:2024/06/17 01:42:33
电子表格自动查询2014新修订小学男女生体重指数(BMI)评分表函数
电子表格;D5性别,E5身高,F5体重,H5体重指数得分.在H5如何合并以下两公式:D5是1(男):IF(F5/(E5*E5)>=20.4,"60",IF(F5/(E5*E5)>=18.2,"80",IF(F5/(E5*E5)>=13.5,"100",IF(F5/(E5*E5)=19.3,"60",IF(F5/(E5*E5)>=17.4,"80",IF(F5/(E5*E5)>=13.3,"100",IF(F5/(E5*E5)
电子表格;D5性别,E5身高,F5体重,H5体重指数得分.在H5如何合并以下两公式:D5是1(男):IF(F5/(E5*E5)>=20.4,"60",IF(F5/(E5*E5)>=18.2,"80",IF(F5/(E5*E5)>=13.5,"100",IF(F5/(E5*E5)=19.3,"60",IF(F5/(E5*E5)>=17.4,"80",IF(F5/(E5*E5)>=13.3,"100",IF(F5/(E5*E5)
![电子表格自动查询2014新修订小学男女生体重指数(BMI)评分表函数](/uploads/image/z/15246980-44-0.jpg?t=%E7%94%B5%E5%AD%90%E8%A1%A8%E6%A0%BC%E8%87%AA%E5%8A%A8%E6%9F%A5%E8%AF%A22014%E6%96%B0%E4%BF%AE%E8%AE%A2%E5%B0%8F%E5%AD%A6%E7%94%B7%E5%A5%B3%E7%94%9F%E4%BD%93%E9%87%8D%E6%8C%87%E6%95%B0%EF%BC%88BMI%29%E8%AF%84%E5%88%86%E8%A1%A8%E5%87%BD%E6%95%B0)
在I2:K6建立体重指数对照表,然后在D5单元格输入以下公式
=IF(D5=1,LOOKUP(F5/(E5*E5),$I$3:$I$6,$K$3:$K$6),LOOKUP(F5/(E5*E5),$J$3:$J$6,$K$3:$K$6))
详见附图附件
![](http://img.wesiedu.com/upload/3/43/343562809be6822c63110f53c820b4ed.jpg)
=IF(D5=1,LOOKUP(F5/(E5*E5),$I$3:$I$6,$K$3:$K$6),LOOKUP(F5/(E5*E5),$J$3:$J$6,$K$3:$K$6))
详见附图附件
![](http://img.wesiedu.com/upload/3/43/343562809be6822c63110f53c820b4ed.jpg)