请教EXCEL统计
答案:3 悬赏:30 手机版
解决时间 2021-11-15 03:49
- 提问者网友：伴风望海
- 2021-11-14 14:19
请教EXCEL统计
最佳答案
- 五星知识达人网友：孤老序
- 2021-11-14 15:55
B2中输入：=IF(AND(C2="",D2=""),"",IF(AND(C2<>0,D2=""),"增",IF(AND(C2="",D2<>0),"减",(C2-D2)/D2*100&"%")))
全部回答
- 1楼网友：执傲
- 2021-11-14 18:20
解决不了的话可以找我
- 2楼网友：纵马山川剑自提
- 2021-11-14 16:49
=IF(AND(C2<>"",D2<>""),10%,IF(AND(C2<>"",D2=""),"增",IF(AND(C2="",D2=""),"",IF(AND(C2="",D2<>""),"减"))))
10% ,根据自己需求修改追问感谢老师的回答,,可能我没说太清楚,C和在都有数的,B列要公式计算(C-D)*100/D追答=IF(AND(C2<>"",D2<>""),(C2-D2)*100/D2,IF(AND(C2<>"",D2=""),"增",IF(AND(C2="",D2=""),"",IF(AND(C2="",D2<>""),"减"))))追问感谢,完美解决问题,
10% ,根据自己需求修改追问感谢老师的回答,,可能我没说太清楚,C和在都有数的,B列要公式计算(C-D)*100/D追答=IF(AND(C2<>"",D2<>""),(C2-D2)*100/D2,IF(AND(C2<>"",D2=""),"增",IF(AND(C2="",D2=""),"",IF(AND(C2="",D2<>""),"减"))))追问感谢,完美解决问题,
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯