格式转换 IF($A4:$C4="","",COUNTIF($A4:$C4,">4")&":"&COUNTIF($
答案:2 悬赏:70 手机版
解决时间 2021-11-28 22:19
- 提问者网友：最美的风景
- 2021-11-28 06:53
格式转换 IF($A4:$C4="","",COUNTIF($A4:$C4,">4")&":"&COUNTIF($A4:$C4,"<5"))
最佳答案
- 五星知识达人网友：掌灯师
- 2021-11-28 07:22
A4:C4的原公式*1就可以转换成数值追问试过，但是会报错
追答=IF(OR(A4="",B4="",C4=""),"",MAX(A4:C4)&":"&MIN(A4:C4))
追答=IF(OR(A4="",B4="",C4=""),"",MAX(A4:C4)&":"&MIN(A4:C4))
全部回答
- 1楼网友：洒脱疯子
- 2021-11-28 08:23
输入
=IF(COUNT(A4:C4)=0,"",COUNTIF(A4:C4,">4")&":"&COUNTIF(A4:C4,"<5"))
=IF(COUNT(A4:C4)=0,"",COUNTIF(A4:C4,">4")&":"&COUNTIF(A4:C4,"<5"))
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯