Header ads

Header ads
» » 51 hàm Excel mới trong Excel 2013

Category Function Explanation
Date and time DAYS  Returns the   number of days between two dates
Date and time ISOWEEKNUM  Returns the   number of the ISO week number of the year for a given date
Engineering BITAND  Returns a   ‘Bitwise And’ of two numbers
Engineering BITLSHIFT  Returns a   value number shifted left by shift_amount bits
Engineering BITOR  Returns a   bitwise OR of 2 numbers
Engineering BITRSHIFT  Returns a   value number shifted right by shift_amount bits
Engineering BITXOR  Returns a   bitwise ‘Exclusive Or’ of two numbers
Engineering IMCOSH  Returns the   hyperbolic cosine of a complex number
Engineering IMCOT  Returns the   cotangent of a complex number
Engineering IMCSC  Returns the   cosecant of a complex number
Engineering IMCSCH  Returns the   hyperbolic cosecant of a complex number
Engineering IMSEC  Returns the   secant of a complex number
Engineering IMSECH  Returns the   hyperbolic secant of a complex number
Engineering IMSINH  Returns the   hyperbolic sine of a complex number
Engineering IMTAN  Returns the   tangent of a complex number
Financial PDURATION  Returns the   number of periods required by an investment to reach a specified value
Financial RRI  Returns an   equivalent interest rate for the growth of an investment
Information ISFORMULA  Returns TRUE   if there is a reference to a cell that contains a formula
Information SHEET  Returns the   sheet number of the referenced sheet
Information SHEETS  Returns the   number of sheets in a reference
Logical IFNA  Returns the   value you specify if the expression resolves to #N/A, otherwise returns the   result of the expression
Logical XOR  Returns a   logical exclusive OR of all arguments
Lookup and   reference FORMULATEXT  Returns the   formula at the given reference as text
Math and   trigonometry ACOT  Returns the   arccotangent of a number
Math and   trigonometry ACOTH  Returns the   hyperbolic arccotangent of a number
Math and   trigonometry ARABIC  Converts a   Roman number to Arabic, as a number
Math and   trigonometry BASE  Converts a   number into a text representation with the given radix (base)
Math and   trigonometry CEILING.MATH  Rounds a   number up, to the nearest integer or to the nearest multiple of significance
Math and   trigonometry COMBINA Returns the number of combinations with repetitions   for a given number of items
Math and   trigonometry COT  Returns the   hyperbolic cosine of a number
Math and   trigonometry COTH  Returns the   cotangent of an angle
Math and   trigonometry CSC  Returns the   cosecant of an angle
Math and   trigonometry CSCH  Returns the   hyperbolic cosecant of an angle
Math and   trigonometry DECIMAL  Converts a   text representation of a number in a given base into a decimal number
Math and   trigonometry FLOOR.MATH  Rounds a   number down, to the nearest integer or to the nearest multiple of   significance
Math and   trigonometry ISO.CEILING  Returns a   number that is rounded up to the nearest integer or to the nearest multiple   of significance
Math and   trigonometry MUNIT  Returns the   unit matrix or the specified dimension
Math and   trigonometry SEC  Returns the   secant of an angle
Math and   trigonometry SECH  Returns the   hyperbolic secant of an angle
Statistical BINOM.DIST.RANGE  Returns the   probability of a trial result using a binomial distribution
Statistical GAMMA  Returns the   Gamma function value
Statistical GAUSS  Returns 0.5   less than the standard normal cumulative distribution
Statistical PERMUTATIONA  Returns the   number of permutations for a given number of objects (with repetitions) that   can be selected from the total objects
Statistical PHI  Returns the   value of the density function for a standard normal distribution
Statistical SKEW.P  Returns the   skewness of a distribution based on a population
Text NUMBERVALUE  Converts   text to number in a locale-independent manner
Text UNICHAR  Returns the   Unicode character that is references by the given numeric value
Text UNICODE  Returns the   number (code point) that corresponds to the first character of the text
Web ENCODEURL  Returns a   URL-encoded string
Web FILTERXML  Returns   specific data from the XML content by using the specified xpath
Web WEBSERVICE  Returns data   from a web service.

About Học viện đào tạo trực tuyến

Xinh chào bạn. Tôi là Đinh Anh Tuấn - Thạc sĩ CNTT. Email: dinhanhtuan68@gmail.com .
- Nhận đào tạo trực tuyến lập trình dành cho nhà quản lý, kế toán bằng Foxpro, Access 2010, Excel, Macro Excel, Macro Word, chứng chỉ MOS cao cấp, IC3, tiếng anh, phần mềm, phần cứng .
- Nhận thiết kế phần mềm quản lý, Web, Web ứng dụng, quản lý, bán hàng,... Nhận Thiết kế bài giảng điện tử, số hóa tài liệu...
HỌC VIỆN ĐÀO TẠO TRỰC TUYẾN:TẬN TÂM-CHẤT LƯỢNG.
«
Next
Bài đăng Mới hơn
»
Previous
Bài đăng Cũ hơn