=IF(H4>=69,"钢化",IF(0<H4<39,"高清",IF(50<H4<69,"专用","
答案:2 悬赏:0 手机版
解决时间 2021-03-09 17:56
- 提问者网友:咪咪
- 2021-03-09 12:39
=IF(H4>=69,"钢化",IF(0<H4<39,"高清",IF(50<H4<69,"专用","""")))。为什么高清的那个不计算
最佳答案
- 五星知识达人网友:西岸风
- 2021-03-09 13:28
H4,H4<39),"高清"=IF(H4>=69,"钢化",应改为;专用","")))
0<39——是两个关联条件;H4<69),",IF(AND(0<,IF(AND(50<H4,H4<,H4<:AND(0<H4
0<39——是两个关联条件;H4<69),",IF(AND(0<,IF(AND(50<H4,H4<,H4<:AND(0<H4
全部回答
- 1楼网友:掌灯师
- 2021-03-09 13:56
正确公式:
=if(h4<20,"e",if(h4<70,"d",if(h4<160,"c",if(h4<320,"b","a"))))
我要举报
如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
点此我要举报以上问答信息
大家都在看
推荐资讯