【Excel】正常18~25，瘦<18，超重25~30，轻胖30~35，中胖35~40，重肥胖>40

来源：百度知道编辑：UC知道时间：2024/06/01 05:04:29

IF(AND(A>=18,A<=25),"正常",IF(A<18,"偏瘦",IF(AND(A<=30,A>=25,)"超重",IF(AND(A>=30,A<=35),"轻度肥胖",IF>40,"重度肥胖","中度"))))
【看看对不对】

不是这样的
if(a<18,"瘦",if(a<25,"正常",if(a<30,"超重",if(a<35,"轻胖",if(a<40,"中胖","重肥胖")))))

=if(a1>40,"重肥胖",if(a1>35,"中胖",if(a1>30,"轻胖",if(a1>25,"超重",if(a1>18,"正常","瘦")))))

或者：
=LOOKUP(A1,{0,18,26,31,36,41;"瘦","正常","超重","轻胖","中胖","重肥胖"})

=if(a>40,"重肥",if(a>=35,"中胖",if(a>=30,"轻胖",if(a>=25,"超重",if(a>=18,"正常","瘦")))))

=IF(A1>40,"重胖",IF(A1>35,"中胖",IF(A1>30,"轻胖",IF(A1>25,"超重",IF(A1>=18,"正常","偏瘦")))))

比较复杂，容易出错，可以考虑使用Vlookup函数，操作见图。