假設係咁樣，
A1 = 23/10/2015 (due date)
A2 = 24/10/2015 (今日)
A3 >> 需要set 做，如果過左A1日子，咁A3 要 show "overdue" 這個字，如果未過，就要show " not due"
請問要點樣set ? (Excel 2007/2010)
Thx !
Excel 應該點樣set ?
2015-10-24 6:04 pm
回答 (2)
2015-11-09 5:25 am
.
A2輸入:
=TODAY()
A3輸入 :
=IF(A2>A1,"overdue","not due")
A2輸入:
=TODAY()
A3輸入 :
=IF(A2>A1,"overdue","not due")
2015-10-25 1:38 am
看不太懂猜一下
A1=預定日期
A2=NOW()
A3=IF(A1>A2,"過期","未過期")
A1=預定日期
A2=NOW()
A3=IF(A1>A2,"過期","未過期")
收錄日期: 2021-05-04 02:02:30
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20151024100403AAl0xIc