作者nanahate (nanahate)
看板Office
标题[算表] excel的if函数二个条件
时间Mon May 24 00:13:29 2021
软体:office excel
版本:2016
=IF(B69>49999,"达交收","")
=IF(B69<-49999,"达交收","")
某一个储存格>49999以上 跟<-49999以上 都想让它显示达交收
这样我公式该怎麽弄?
--
※ 发信站: 批踢踢实业坊(ptt.cc), 来自: 124.6.129.154 (菲律宾)
※ 文章网址: https://webptt.com/cn.aspx?n=bbs/Office/M.1621786411.A.447.html
1F：→ TANEKI: 写长一点 =if(B69>49999,"达交收",if(B69<-49999,"达交收 05/24 02:51
2F：→ TANEKI: "," ")) 如果你的条件包含49999跟-49999的话 那就要改为 05/24 02:51
3F：→ TANEKI: >=49999 跟<=49999 如果是只要50000跟-50000就不用改 05/24 02:51
4F：→ soyoso: =if(abs(b69)>49999,"达交收","") 05/24 07:01
5F：→ nanahate: 谢谢两位 帮助很大 05/25 16:37