excel两个if函数怎么合并到一起

2025-04-29 06:11:06
推荐回答(1个)
回答1:

=IF(L4=0,IF(M4<=0,0,IF(M4<=10,8,IF(M4<=160,8+0.4*(M4-10),IF(M4<=1010,64+0.38*(M4-150),"超重")))),IF(L4<=1,80,IF(L4<=3,77,IF(L4<=10,72,IF(L4<=20,65,"超大")))))