此时我们用IF函数来实现健康状况选择,在“F5”单元格中输入:
=IF(L3="男",IF(H3>(D3-100)*0.9*1.5,"要小心了!你已经属于重度肥胖!",IF(H3>(D3-100)*0.9*1.3,"注意啦!你已经属于中度肥胖!",IF(H3>(D3-100)*0.9*1.2,"注意啦!你已经属于轻度肥胖!",IF(H3>(D3-100)*0.9*1.1,"注意了!你已经超重啦!",IF(H3>(D3-100)*0.9*0.9,"恭喜你!你的身材一级棒!","同志,你该补充营养了!"))))),IF(H3>((D3-100)*0.9-2.5)*1.5,"要小心了!你已经属于重度肥胖!",IF(H3>((D3-100)*0.9-2.5)*1.3,"注意啦!你已经属于中度肥胖!",IF(H3>((D3-100)*0.9-2.5)*1.2,"注意啦!你已经属于轻度肥胖!",IF(H3>((D3-100)*0.9-2.5)*1.1,"注意了!你已经超重啦!",IF(H3>((D3-100)*0.9-2.5)*0.9,"恭喜你!你的身材一级棒!","同志,你该补充营养了!"))))))