血腥玛丽 发表于 2021-12-14 13:35:28

=IF(B3=0,"",TEXT(B3,"越级投诉0次"))
抛个砖，单独判定，再合并评价

唐海江 发表于 2021-12-23 03:01:01

=TextJoin(",",1,IF(B3:K3*{1,-1,-1,1,-1,-1,-1,-1,1,1}>{0,-100,-40,6.9999,-99,-99,-0.7,-0.95,0.15,0},{"越级投诉","满意率","参评率","修复时长","装移机首次","修障首次2小时内响应","当日安装率","当天修复率","退单率","云投诉"}&B3:K3,""))

一行一行运行，供参考

成人高考 发表于 2022-1-4 14:51:26

可以了，但是转换过来后，当天修复率、当天安装率和退单率都变成小数字，不是百分比了

灞桥风雨 发表于 2022-1-9 01:45:31

可以加入几项指标没达标吗，我看那个投诉后面可以加上"张"吗？

捷可 发表于 2022-1-18 12:54:17

感谢大神，现在就最后一个问题了，越级投诉后云投诉后面能加个“张”字吗

张天华 发表于 2022-1-20 07:25:09

=TextJoin(",",1,IF(B6:K6*{1,-1,-1,1,-1,-1,-1,-1,1,1}>{0,-100,-40,6.9999,-99,-99,-0.7,-0.95,0.15,0},{"越级投诉","满意率","参评率","修复时长","装移机首次","修障首次2小时内响应","当日安装率","当天修复率","退单率","云投诉"}&ROUND(B6:K6*{1,1,1,1,1,1,100,100,100,1},2)&{"张","%","%","H","%","%","%","%","%","张"},""))&TEXT(SUM(N(B6:K6*{1,-1,-1,1,-1,-1,-1,-1,1,1}>{0,-100,-40,6.9999,-99,-99,-0.7,-0.95,0.15,0})),"\,0项未达标;;")

天晓未然 发表于 2022-1-21 04:53:01

方便加个好友吗

青松难改鬓毛催 发表于 2022-1-27 06:51:55

有问题可以加QQ群853025894

用户杰 发表于 2022-1-27 08:38:06

=TextJoin(",",1,IF(B3:K3*{1,-1,-1,1,-1,-1,-1,-1,1,1}>{0,-100,-40,6.9999,-99,-99,-0.7,-0.95,0.15,0},{"越级投诉","满意率","参评率","修复时长","装移机首次","修障首次2小时内响应","当日安装率","当天修复率","退单率","云投诉"}&TEXT(B3:K3,"[<1]0.##%"),""))&TEXT(SUM(N(B3:K3*{1,-1,-1,1,-1,-1,-1,-1,1,1}>{0,-100,-40,6.9999,-99,-99,-0.7,-0.95,0.15,0})),"0项未指标;;")

阿飞周 发表于 2022-1-28 06:34:55

=IF(B3=0,"",TEXT(B3,"越级投诉0次"))
抛个砖，单独判定，再合并评价
页: 1 [2] 3
查看完整版本: 根据通报数据自动生成评语