A.Average函數(shù) B.Daverage函數(shù) C.DSUM函數(shù) D.Dcount函數(shù)
A.=IF(AND(H3>20,I3=""工程師""),TRUE,F(xiàn)ALSE),然后拖動填充。 B.=AND(H3>20,I3=""工程師""),然后拖動填充。 C.=IF(AND(H3>20,I3=""工程師""),是,否),然后拖動填充。 D.=IF(AND(H3>20,I3=""工程師""),""是"",""否""),然后拖動填充。
A.=YEAR(TODAY())-YEAR(1995-11-25) B.=YEAR(TODAY())-YEAR(""1995-11-25"") C.=YEAR(DATE())-YEAR(DATE(1995,11,25)) D.=YEAR(TODAY())-YEAR(DATE(1995,11,25))