excelä¸ç¨todayå½æ°è¿åå½åæ¥æ并设置æ¥ææ ¼å¼ã
1ãä¾å¦æ¾ç¤ºä»å¤©çæ¥æã
è¾å ¥å ¬å¼=today()ã
2ãä¾å¦todayä¸andãifå½æ°ç»åè¿è¡åºé¾åæã
è¾å ¥å ¬å¼=today()-B2ã
3ãandå½æ°è¡¨ç¤ºæ£æ¥æ¯å¦ææåæ°å为TRUEï¼å¦æææåæ°å为TRUEï¼åè¿åTRUEã
è¯æ³æ ¼å¼=and(logical1,logical2, ...)ã
ifå½æ°è¡¨ç¤ºå¤ææ¯å¦æ»¡è¶³æ个æ¡ä»¶ï¼å¦æ满足è¿åä¸ä¸ªå¼ï¼å¦æä¸æ»¡è¶³è¿åå¦ä¸ä¸ªå¼ã
è¯æ³æ ¼å¼=if(æ¡ä»¶ï¼ç»æ1ï¼ç»æ2)
è¾å ¥å ¬å¼=IF(TODAY()-B2<=90,"æ¯","å¦")ã