MATH AND TRIG FUNCTIONS
1. ACOS:- In Microsoft Excel “ACOS” function returns the arccosine
(i.e. inverse of cosine) of a given number in radians in the range of 0 to Pi(Õ).
Syntax of ACOS function:-
=ACOS(number)
Argument:-
number:- The value between -1 to +1.
Example of ACOS function:-
The
following pictures show the example of the
ACOS function.
2. ACOSH:- In Microsoft Excel “ACOSH” function returns the inverse
hyperbolic cosine of number.
Syntax of ACOSH function:-
=ACOSH(number)
Argument:-
number:- This is the positive(+) real number
and it must be greater than or equal to 1.
Example of ACOSH function:-
The
following pictures show the example of the
ACOSH function.
3. ASIN:- In Microsoft Excel “ASIN” function returns the arcsine
(i.e. inverse sine) of a supplied number in radians in range -Õ/2 to Õ/2.
Syntax of ASIN function:-
=ASIN(number)
Argument:-
number:- The numeric value between -1 to 1.
Example of ASIN function:-
The
following pictures show the example of the
ASIN function.
4. ASINH:- In Microsoft Excel “ASINH” function returns the inverse
hyperbolic sine of a supplied number.
Syntax of ASINH function:-
=ASINH(number)
Argument:-
number:- A real number.
Example of ASINH function:-
The
following pictures show the example of the
ASINH function.
5. ATAN:- In Microsoft Excel “ATAN” function returns the arctangent
(i.e. inverse tangent) of a supplied number in radians and in the range of -Õ/2 to Õ/2.
Syntax of ATAN function:-
=ATAN(number)
Argument:-
number:- It is the numeric value.
Example of ATAN function:-
The
following pictures show the example of the
ATAN function.
6. ATAN2:- In Microsoft Excel “ATAN2” function returns arctangent
(i.e. inverse tangent) of a supplied set of x and y coordinates in radians
between -Õ to Õ.
Syntax of ATAN2 function:-
=ATAN2(x_num,y_num)
Argument:-
x_num:- The x - coordinate of the point.
y_num:- The y - coordinate of the point.
Example of ATAN2 function:-
The
following pictures show the example of the
ATAN2 function.
7. ATANH:- In Microsoft Excel “ATANH” function returns the inverse
hyperbolic tangent of a supplied number.
Syntax of ATANH function:-
=ATANH(number)
Argument:-
number:- A real number between -1(but not
equal to -1) to 1.
Example of ATANH function:-
The
following pictures show the example of the
ATANH function.
8. COS:- In Microsoft Excel “COS” function returns the cosine of an
supplied angel.
Syntax of COS function:-
=COS(number)
Argument:-
number:- The angle in radian.
Example of COS function:-
The
following pictures show the example of the
COS function.
9. COSH:- In Microsoft Excel “COSH” function calculates the
hyperbolic cosine of a number.
Syntax of COSH function:-
=COSH(number)
Argument:-
number:- It is the real number.
Example of COSH function:-
The
following pictures show the example of the
COSH function.
10. DEGREES:- In Microsoft Excel “DEGREES” function coverts the radians
into degrees or angle form.
Syntax of DEGREES function:-
=DEGREES(angle)
Argument:-
angle:- The angle in radians that is
converted to degrees.
Example of DEGREES function:-
The
following pictures show the example of the
DEGREES function.
11. PI:- In Microsoft Excel “PI” function returns the constant
value of Pi, accurate to 15 digits i.e. 3.14159265358979 otherwise it gives
3.141592654.
Syntax of PI function:-
=PI()
Argument:-
Example of PI function:-
The
following pictures show the example of the
PI function.
12. RADIANS:- In Microsoft Excel “RADIANS” function converts degrees
into radian form.
Syntax of RADIANS function:-
=RADIANS(angle)
Argument:-
angle:- The angle in degrees to be converted
to radians.
Example of RADIANS function:-
The
following pictures show the example of the
RADIANS function.
13. SIN:- In Microsoft Excel “SIN” function returns the sine value
of an angle.
Syntax of SIN function:-
=SIN(number)
Argument:-
number:- The angle in radian.
Example of SIN function:-
The
following pictures show the example of the
SIN function.
14. SINH:- In Microsoft Excel “SINH” function returns the hyperbolic
sine of a given number.
Syntax of SINH function:-
=SINH(number)
Argument:-
number:- It is a real number.
Example of SINH function:-
The
following pictures show the example of the
SINH function.
15. SQRTPI:- In Microsoft Excel “SQRTPI” function returns the square
root of a number [number*pi] which is multiplied by pi(Õ).
Syntax of SQRTPI function:-
=SQRTPI(number)
Argument:-
number:- Positive numeric value.
Example of SQRTPI function:-
The
following pictures show the example of the
SQRTPI function.
16. TAN:- In Microsoft Excel “TAN” function returns the tangent of
an angle.
Syntax of TAN function:-
=TAN(number)
Argument:-
number:- The angle in radians.
Example of TAN function:-
The
following pictures show the example of the
TAN function.
17. TANH:- In Microsoft Excel “TANH” function calculate the
hyperbolic tangent of a number.
Syntax of TANH function:-
=TANH(number)
Argument:-
number:- It is a real number.
Example of TANH function:-
The
following pictures show the example of the
TANH function.
18. LN:- In Microsoft Excel “LN” function returns the natural
logarithm of a given number.
Syntax of LN function:-
=LN(number)
Argument:-
number:- The number to take the natural
logarithm.
Example of LN function:-
The
following pictures show the example of the
LN function.
19. LOG:- In Microsoft Excel “LOG” function returns the logarithm of
a given number using a supplied base. If the base is not supplied then the
default base is 10.
Syntax of LOG function:-
=LOG(number,[base])
Argument:-
number:- Number for which you got the
logarithm.
base:- Base of the logarithm is an optional
part and if omitted the default base is 10.
Example of LOG function:-
The
following pictures show the example of the
LOG function.
20. LOG10:- In Microsoft Excel “LOG10” function returns the logarithm
value of a given number having the base 10.
Syntax of LOG10 function:-
=LOG10(number)
Argument:-
number:- The positive real number to calculate
the logarithm of.
Example of LOG10 function:-
The following pictures show the example of the LOG10 function.
0 Comments:
Post a Comment