问题：多层If判断
函数公式解决：
=IF(N10>=90,,IF(N10>=80,10,IF(N10>=70,30,IF(N10>=60,50,45))))
=IF(N10<60,45,IF(N10<70,50,IF(N10<80,30,IF(N10<90,10,))))
=IFS(N10<60,45,N10<70,50,N10<80,30,N10<90,10,1,)
=SWITCH(TRUE,N10<60,45,N10<70,50,N10<80,30,N10<90,10,0)
=XLOOKUP(N10,{0;60;70;80;90},{45;50;30;10;0},,-1)
暂无评论
2023-12-26
2023-12-19
2023-12-19
2023-12-19
2023-12-19
2023-12-19
2023-12-19
2023-12-12
2023-12-12
2023-12-12
2024-05-20
2024-05-20
2024-05-18
2024-05-18
2024-05-18
2024-05-18
2024-05-18
2024-05-18
2024-05-18
2024-05-18
2024-05-18
2024-05-18
2024-05-18
2024-05-18
2024-05-17
2024-05-17
2024-05-17
2024-05-17
2024-05-17