{oapdf_gg}
Office software is closely linked to the PDF,the PDF is also must have to control!      Set home Page  Add to Favorites  
You are here:Home > OA application skills > EXCEL skills
EXCEL skills
Excel function of mathematics and the application of trigonometric functions Detailed tutorial (with examples)
Finishing by: Date:2009-04-11 13:10:48 Popularity: Tags:tutorial


Third, the use of common mathematical functions skills - rounded

Practical work in mathematics, especially in the financial calculations are often encountered the problem of rounding. Although, excel cells format allows you to define the number of decimal places, but in actual operation, we found that, in fact, the number itself does not truly rounded, but the results seem to show that the rounding. If the rounding method in this case, often in the financial operations will be a few errors, which is not allowed the financial operations. Is it simple and practical approach to real rounding it? In fact, Excel has a function in this regard, and this is the ROUND function, it can return a specified number of digits after the rounding of figures.

Provided in Excel "Mathematics and trigonometric functions," provided a ROUND (number, num_digits) function, which is based on the function of the median specified, the figures are rounded. This function has two parameters, namely the number and num_digits. Number of which is to be rounded figures; num_digits is the hope that the number of digits after the decimal point. As shown in Figure 3:

B2 cells in the initial data for the 0.123456, B3 of the initial data .234567, will be rounding them. In cell C2, type "= ROUND (B2, 2)", the decimal point two digits after the reservation has been 0.12,0.23. In cell D2, type "= ROUND (B2, 4)", is to retain four decimal digits, the 0.1235,0.2346.


Figure 3 rounded figures

for rounding off the figures, but also can use the INT (integer function), but as a result of this function is defined as a return to Real after rounding the integer value. Thus, rounding INT function or need some skills, that is, the addition of 0.5, to achieve the purpose of rounding. Still to Figure 3 as an example, if the INT function, the C2 the formula should be written: "= INT (B2 * 100 +0.5) / 100".

Finally should be noted that: In this paper, all formulas Excel2000 in Excel97 and verify passed, amend the reference cell which conditions and logical values that can be used similar to other occasions.

Note: Excel's list of math and trigonometric functions

ABS function worksheet to return to the absolute value of parameter
ACOS function worksheet return the inverse cosine value of the number of
ACOSH worksheet function parameters to return the value of anti-cosh
ASIN worksheet function arcsine return value parameter
ASINH worksheet function return parameter hyperbolic sine value of anti-
ATAN function worksheet arctangent return value parameter
ATAN2 worksheet function set back to the X and Y coordinate values of the arctangent value
ATANH worksheet function return hyperbolic parameter values of the anti-
CEILING function worksheet parameters Number along the direction of increasing absolute value, rounded to the nearest whole number or base
COMBIN worksheet function number calculated from a given collection of objects to extract the number of combinations of a number of objects
COS function worksheet returned to the cosine value of angle
COSH function worksheet cosh return value parameter
COUNTIF worksheet function calculated given the conditions of the region to meet the specific number of cells
DEGREES function worksheet will be converted to degree of curvature of
EVEN worksheet function return direction along the absolute increase after rounding the nearest even number
EXP function worksheet return the n th e constant e equal to 2.71828182845904 power is the natural logarithm of base
FACT worksheet function return the number of factorial, factorial of a number equal to 1 * 2 * 3 *...* the few
FACTDOUBLE worksheet function return Number of half-factorial parameters
FLOOR function worksheet parameters Number will be reduced along the direction of the absolute value to the end of rounding to the nearest equivalent to a multiple of significance of
GCD function worksheet return two or more of the common denominator integer
INT function worksheet return it after a few round-off integer value
LCM worksheet function return the least common multiple integer
LN worksheet function returns a number of natural logarithm natural logarithm of a constant e (2.71828182845904) to the end
LOG worksheet function specified by the base and returned to the logarithm of a number
LOG10 function worksheet to 10 for the return at the end of logarithmic
MDETERM worksheet function to return an array of the value of the determinant of the matrix
MINVERSE worksheet function return matrix inverse matrix array
MMULT worksheet function to return to the matrix product of two array results
MOD worksheet function return the number of division two of the remainder of the sign with the results of the same divisor
MROUND worksheet function specified parameters to return to base after rounding the value
MULTINOMIAL worksheet function return parameters and the parameters of the factorial and the factorial ratio of the product
ODD function worksheet return value to specify rounding to odd-numbered after the
PI worksheet function figures 3.14159265358979 return, that is the mathematical constant pi, accurate to 15 decimal places
POWER worksheet function return given by the number of power
PRODUCT worksheet function all parameters are given in order to multiply the number and value of the return of the product
QUOTIENT function worksheet back to the integer part of the function can be used for the fractional part ofÉáµô's
RADIANS function worksheet will be converted to radian angle
RAND worksheet function return greater than or equal to 0 less than 1 uniformly distributed random number
RANDBETWEEN worksheet function return is located between the two designated a random number
ROMAN worksheet function text will be converted to Arabic numerals Roman numerals form of
ROUND worksheet function return a specified number of digits after the rounding of figures
ROUNDDOWN worksheet function value close to zero, the downward (the direction of reducing the absolute value) the number of round-off
ROUNDUP function worksheet away from zero and upward (the direction of increasing absolute value) the number of round-off
SERIESSUM worksheet function return based on the following formula and of the power series:
SIGN function worksheet return the number of symbols when the number of positive return 1 return 0 is zero for the negative return -1
SIN function worksheet returned to the sine value of angle
SINH function worksheet return the hyperbolic sine of a number of value
SQRT worksheet function return is the square root
SQRTPI worksheet function return a number of the square root of pi multiplied by
SUBTOTAL worksheet function to return to data list or database subtotals
SUM worksheet function to return to a range of all the figures
SUMIF worksheet function conditions specified sum on a number of cell
SUMPRODUCT worksheet function in a given array of groups will be among the array elements corresponding to multiply, and return the product and the
SUMSQ worksheet function to return to the square of all the parameters and
SUMX2MY2 worksheet function array corresponds to the return of the two values and the square of difference
SUMX2PY2 worksheet function array corresponds to the return of the two values and the sum of the square, the square of the Canadian total in the regular use of statistical computing
SUMXMY2 worksheet function array corresponds to the return of the two values and the square of the difference
TAN function worksheet returned to the tangent of the angle
TANH worksheet function return the hyperbolic tangent of a number of value
TRUNC function worksheet part will be truncated decimal digit, return an integer

there isArticle InformationsComment Information
Category column

Site Help | Site Map | Feedback |
OAPDF.COM Copyright 2009 V1.1