求EXCEL帮助，关于IF判断公式的问题~~~~~
答案:5 悬赏:0 手机版
解决时间 2021-11-25 12:22
- 提问者网友：树红树绿
- 2021-11-25 03:51
求EXCEL帮助，关于IF判断公式的问题~~~~~
最佳答案
- 五星知识达人网友：轮獄道
- 2021-11-25 05:16
在B11中输入或复制粘贴下列公式
=IF(A12="","",TEXT(A12-A11,"升;降;平"))
或
=IF(A12="","",IF(A12>A11,"升",IF(A12=A11,"平","降")))
下拉填充
=IF(A12="","",TEXT(A12-A11,"升;降;平"))
或
=IF(A12="","",IF(A12>A11,"升",IF(A12=A11,"平","降")))
下拉填充
全部回答
- 1楼网友：纵马山川剑自提
- 2021-11-25 08:57
太深奥了，表示不懂。
- 2楼网友：一叶十三刺
- 2021-11-25 07:23
=if(A12="","",if(A12>A11,"升",if(A12=A11,"平","降")))
- 3楼网友：舍身薄凉客
- 2021-11-25 07:09
在B12输入以下公式，然后向下填充公式
=IF(A12="","",IF(A12>A11,"升",IF(A12=A11,"平","降")))
=IF(A12="","",IF(A12>A11,"升",IF(A12=A11,"平","降")))
- 4楼网友：有你哪都是故乡
- 2021-11-25 06:13
B11=IF(INDIRECT("a"&ROW(A11)*2-10)="","",TEXT(INDIRECT("a"&ROW(A11)*2-10)-INDIRECT("b"&ROW(A11)*2-11),"升;降;平"))
向下填充公式。
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯