求大神看看EXCEL代码错误出在哪里

2025-04-28 20:29:02
推荐回答(2个)
回答1:

第8周以前,若是周一到周五的话,要显示什么?
IF(OR(ROUNDUP((B1-DATE(2018,1,0))/7,0)={8,10,12,14,16,18,20,22,24,26,28,30,32}),IF(OR(D1={"星期一","星期二","星期三","星期四","星期五"}),1,"①"),IF(OR(D1={"星期六","星期日"}),"①","显示什么"))

回答2:

最近看上梦神的