我常用的函数让你参考一下：一、日期函数：Date,Datedif,Day,Hour,Minute,Month,Now,Second,Today,Weekday,Year;二、信息函数：Isblank,Iserror;三、逻辑函数：And,Flase,If,Not,Or,Ture;四、查询与引用函数：Choose,Column,Columns,Hlookup,Hyperlink,Index,Indirect,Lookup,Match,Offset,Row,Rows,Vlookup;五、数学与三角函数：Abs,Countif,Floor,Int,Mod,Rand,Round,Sqrt,Subtotal,Sum,Sumif,Sumprod...
|
