楼主:
nanahate (nanahate)
2021-05-24 00:13:29软件:office excel
版本:2016
=IF(B69>49999,"达交收","")
=IF(B69<-49999,"达交收","")
某一个储存格>49999以上 跟<-49999以上 都想让它显示达交收
这样我公式该怎么弄?
作者:
TANEKI (TA NE KI)
2021-05-24 02:51:00写长一点 =if(B69>49999,"达交收",if(B69<-49999,"达交收"," ")) 如果你的条件包含49999跟-49999的话 那就要改为>=49999 跟<=49999 如果是只要50000跟-50000就不用改
作者: soyoso (我是耀宗) 2021-05-24 07:01:00
=if(abs(b69)>49999,"达交收","")