wps表格公式大全（国外英文资料）.doc

wps表格公式大全（国外英文资料） Math and trig functions ABS returns the absolute value of the number ACOS returns the inverse cosine of the number ACOSH returns the inverse hyperbolic cosine of the number ASIN returns the inverse sine of the number ASINH returns the inverse hyperbolic sine of the number The ATAN returns the value of the number The ATAN2 is going from X and Y to the inverse tangent ATANH returns the inverse hyperbolic tangent of the number The CEILING is a multiple of the nearest integer, or the nearest valid number Cosine returns the cosine of the number COMBIN calculates the number of combinations of several objects from a given number of object collections COSH returns the hyperbolic cosine of the number DEGREES converts radians to DEGREES EVEN put the number up into the nearest accidentally integer EXP returns e to the specified number of powers FACT returns the factorial of the number FACTDOUBLE returns the double factorial of the number FLOOR rounding down the number in the zero direction The GCD returns the maximum number of common divisors INT takes the number down to the nearest integer LCM returns the least common multiple of integer arguments. The natural log of the log returns the number LOG returns the logarithm of the base number of the number LOG10 returns the common logarithm of the number MINVERSE returns the inverse matrix of the array matrix MULTINOMIAL return parameter and factorial and various parameters of the ratio of factorial product MDETERM returns the value of the matrix determinant of an array MMULT returns the matrix product of two arrays The MOD returns the remainder of the two Numbers The MROUND returns a number that is returned to the desired multiple ODD gives the number up to the nearest ODD integer PI returns PI POWER returns the POWER of a number PRODUCT multiplies all the Numbers given in the form of arguments The QUOTIENT returns an integer part of the business that is used to the decimal portion of the business. RADIANS conve