120个常用函数集

A类1abs51day2average52days3603averagea53dsum4and54dollar5addressE类55evaluate6areas56exact7asc57emonthC类8ceiling58even9count59exp10countaF类60find11counif61floor12countblank62false13cell63frequency14code64fixed15charG类65get.cell16choose66gcd17cleanH类67hlookup18column68hour19columns69hyperlink20combinI类70if21concatenaet71intD类22date72index23datedif73indirect24datestring74iserror25datevalue75isblank26iseven76offset10127isnumberP类77powerT类10228isodd78proper10329istext79product104L类30largeQ类80quotient10531lenR类81right10632lenb82rightb10733left83rept10834leftb84row10935lower85rows11036lcm86rank11137lookup87randU类112M类38max88randupV类11339maxa89randdown11440min90randbetweenW类11541mina91rmb11642mod92replace11743midS类93sum11844minute94search11945mode95sumif其它120N类46not96second47n97sqrt48now98subtatol49networkdays99sumproductO类50or100small学无止境substitutetruetypetrimtimetodaytimevaluetrunctransposettextuppervaluevlookupweekdayworkdayweeknumwidecharyear&学无止境