Google Sheets if和ifs语句
Google Sheets if和ifs语句
提问于 2022-04-15 01:49:34
我有一系列的结果数据在1-9之间，我想转换成一个等级。
=IFS(I2<2,"2B",I2<3,"2P",I2<4,"2A",I2<5,"3B",I2<6,"3P",I2<7,"3A",I2<8,"4B",I2<9,"4P",I2<10,"4A",I2<11,"5B")我的问题是，当数字是小数时，如何包含一个等级。在.4之上，等级保持下来，在.4之上，它在上升。例如6.4 ="3A"，6.6="4B“
回答 2
Stack Overflow用户
发布于 2022-04-15 08:49:15
尝试：
=IFS(I2<2.5, "2B", I2<3.5, "2P", I2<4.5, "2A", I2<5.5, "3B", I2<6.5, "3P",
I2<7.5, "3A", I2<8.5, "4B", I2<9.5, "4P", I2<10.5, "4A", I2<11.5, "5B")Stack Overflow用户
发布于 2022-04-16 20:41:55
你可以试试圆形函数。
=IFS(round(I2)<2,"2B",round(I2)<3,"2P",round(I2)<4,"2A",round(I2)<5,"3B",round(I2)<6,"3P",round(I2)<7,"3A",round(I2)<8,"4B",round(I2)<9,"4P",round(I2)<10,"4A",round(I2)<11,"5B")页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/71879245
复制相关文章
相似问题
腾讯云开发者
