三角函数-EXCEL(国外英语资料).docVIP

三角函数-EXCEL(国外英语资料) Use: returns the absolute value of a parameter. Syntax: ABS (number) Argument: number is a real number that needs to be evaluated for its absolute value. Example: if A1=-16, then the formula =ABS (A1) returns 16. 2.ACOS Use: returns the inverse cosine value of the parameter represented by radians, with a range of 0~ pi. Syntax: ACOS (number) Parameter: number is the cosine value of an angle, and the size is between -1 and 1. Example: if A1=0.5, then the formula =ACOS (A1) returns 1.047197551 (that is, PI /3 radians, that is, 600); and the formula =ACOS (-0.5) *180/PI () returns 120 degrees. 3.ACOSH Use: returns the inverse hyperbolic cosine of the parameter. Syntax: ACOSH (number) Argument: number must be greater than or equal to 1. Example: the formula =ACOSH (1) is equal to 0; the result of =ACOSH (10) is equal to 2.993223. 4.ASIN Purpose: returns the argument string value of the parameter. Syntax: ASIN (number) Parameter: Number is the sine value of an angle, and its size is between -1 and 1. Example: if A1=-0.5, then the formula =ASIN (A1) returns -0.5236 (- PI /6 radians); and the formula =ASIN (A1) *180/PI () returns -300. 5.ASINH Use: returns the inverse hyperbolic sine of the parameter. Syntax: ASINH (number) Argument: number is any real number. Example: the formula =ASINH (-2.5) returns -1.64723; =ASINH (10) returns 2.998223. 6.ATAN Purpose: returns the tangent value of the parameter. The value returned is expressed in radians, and the size is between PI /2 and PI /2. Syntax: ATAN (number) Argument: number is the tangent of an angle. If the cost represents the returned tangent value, the result is multiplied by 180/PI (). Example: the formula =ATAN (1) returns 0.785398 (PI /4 radians); =ATAN (1) *180/PI () returns 450. 7.ATAN2 Use: returns the tangent value of the given X and Y in the Cartesian coordinate system. It is equal to the angle between the X axis and the line between the origin point and the given point (x_num, y_num), and is be