Math is way cool and here is a website to prove it. Do you remember those kaleidoscopes when you were a kid? This is the computer version.
Take a peek at www.subtlebody-images.com, you will love it . There are all kinds of varieties, like the one you see here. Well, this one is just a picture. The website shows the moving, animated version. On some, the design reacts to the movement of the mouse. Kind of like when you would spin the kaleidoscope and the image would shift.
I came across this on StumbleUpon, which I think I might become addicted to. Just set up your preferences and you will find yourself discovering some really amazing websites.
Enjoy!
![Reblog this post [with Zemanta]](http://img.zemanta.com/reblog_e.png?x-id=f08af611-f937-4563-a43f-d15e87e56f52)
The most popular function in Excel is the Sum function, but did you know that Excel can do so much more than that? So be looking for the reference posts to various categories of the functions (formulas) feature in Excel.
Here you will find a list of functions designed specifically for math and trigonometry. How super fun is THAT!?
You will find the following information for each function:
1. Function name; and
2. Function definition.
NOTE: In the description you will find the function syntax and a description of each argument. Arguments that appear in bold text are required; arguments that do not appear in bold text are option. All function arguments must be entered in the order show and you must not add any spaces between or within arguments. If you need to enter spaces in a text argument or a reference, the argument must be enclosed in double quotation marks.
This list was compiled using several resources to give you the most complete information to put them to use, without over-complicating them. This is MATH, so you might want to refresh you math terminology to start.
| Function | Description |
| ABS | Returns the absolute value of a number and takes the form =ABS(number). If a number is negative, this function simply removes the sign, making it a positive number. |
| ACOS | Returns the arccosine of a number in radians and takes the form =ACOS(number), in which number is the cosine of an angle. |
| ACOSH | Returns the inverse hyperbolic cosine of a number and takes the form =ACOSH(number), in which number must be >=1. |
| ASIN | Returns the arcsine of a number in radians and takes the form =ASIN(number), where number is the sine of the angle you want and must be from -1 to 1. |
| ASINH | Returns the inverse hyperbolic sine of a number and takes the form =ASINH (number). |
| ATAN | Returns the arctangent of a number and takes the form =ATAN(number), where number is the tangent of an angle. |
| ATAN2 | Returns the arctangent from x- and y-coordinates, in radians, and takes the form =ATAN2(x_num,y_num), where x_num is the x-coordinate of the point and y_num is the y-coordinate of the point. A positive result represents a counterclockwise angle from the x-axis; a negative result represents a clockwise angle. |
| ATANH | Returns the inverse hyperbolic tangent of a number and takes the form =ATANH(number), where number must be between (not including) -1 and 1. |
| CEILING | Rounds a number to the nearest integer or to the nearest multiple of significance and takes the form =CEILING(number,multiple) where number and multiple must be numeric and have the same sign. If they have different signs, Excel returns the #NUM! error value. |
| COMBIN | Determines the number of possible group comginations that can be derived from a pool of items and takes the form =COMBIN(number number_chosen), where number is the total items in the pool and number_chosen is the number of items you want in each group. |
| COS | Returns the cosine of an angle. The complement of the SIN function. It takes the form =COS(number), where number is the angle in radians. |
| COSH | Returns the hyperbolic cosine of a number and takes the form =COSH(number), where number is any real number. |
| DEGREES | Converts radians to degrees and takes the form =DEGREES(angle), where angle represents an angle measured in radians. |
| EVEN | Rounds a number up to the nearest even integer and takes the form =EVEN(number). Negative numbers are correspondingly rounded down. |
| EXP | Computes the value of the constant e (approximately 2.71828183) raised to the power specified by its argument and take the form =EXP(number). The EXP function is the inverse of the LN function. |
| FACT | Returns the factorial of a number and takes the form =FACT(number), where number is a positive integer. |
| FACTDOUBLE | Returns the double factorial of a number and takes the form =FACT(number), where number is a positive integer. |
| FLOOR | Rounds a number down to the nearest given multiple and takes the form =FLOOR(number,multiple), where number and multiple must be numeric and have the same sign. If they have different signs, Excel returns the #NUM! error value. |
| GCD | Returns the greatest common divisor of two or more integers (the largest integer that divides both number1 and number2 without a remainder) and takes the form =GCD(number1,number2,…), where numbers are 1 to 30 positive integer values. |
| INT | Rounds numbers down to the nearest integer and takes the form =INT(number). When number is negative, INT also rounds that number down to the nearest integer. |
| LCM | Returns the least common multiple of integers (the smallest positive integer that is a multiple of all arguments), takes the form =LCM(number1,number2,…), and accepts up to 29 numeric integer arguments. |
| LN | Returns the natural (base e) logarithm of the positive number referred to by its argument and takes the form =LN(number). LN is the inverse of the EXP function. |
| LOG | Returns the logarithm of a positive number using a specified base and takes the form =LOG(number,base). If you don’t include the base argument, Excel assumes the base is 10. |
| LOG10 | Returns the base-10 logarithm of a number and takes the form =LOG10(number), where number is a positive real number. |
| MDETERM | Returns the matrix determinant of an array and takes the form =MDTERM(array), where array is a numeric array with an equal number of rows and columns. |
| MINVERSE | Returns the inverse matrix for the matrix stored in an array and takes the form =MINVERSE(array), where array is a numeric array with an equal number of rows and columns. |
| MMULT | Returns the matrix product of two arrays (resulting in an array with the same number of rows as array1 and the same number of columns as array2) and takes the form =MMULT(array1,array2). |
| MOD | Returns the remainder from division operation (modulus) and takes the form =MOD(number,divisor). If number is smaller than divisor, the result of the function equals number. If number is exactly divisible by divisor, the function returns 0. If divisor is 0, MOD returns the #DIV/0! Error value. |
| MROUND | Rounds any number to a multiple you specify and takes the form =MROUND(number,multiple), where number and multiple must both have the same sign. The function rounds up if the remainder after dividing number by multiple is at least half the value of multiple. |
| MULTINOMIAL | Returns the ratio of the factorial of a sum of values to the product of factorials and takes the form =MULTINOMIAL(num1, num2, …), where nums are up to 29 values for which you want to find the multinomial. |
| ODD | Rounds a number up to the nearest odd integer and takes the form =ODD(number). Negative numbers are correspondingly rounded down. |
| PI | Returns the value of pi, accurate to 14 decimal places (3.14159265358979), and takes the form –PI(). It takes no arguments, but you must still enter empty parentheses after the function name. To calculate the area of a circle, multiply the square of the circle’s radius by the PI function. |
| POWER | Returns the result of a number raised to a power and takes the form =POWER(number,power), where number is the base number and power is the exponent to which the base number is raised. |
| PRODUCT | Multiplies all the numbers referenced by its arguments, takes the form =PRODUCT(number1,number2,…), and can take as many as 30 arguments. Text, logical values, and blank cells are ignored. |
| QUOTIENT | Returns the integer portion of a division and takes the form =QUOTIENT(numerator,denominator), where numerator is the dividend and denominator is the divisor. |
| RADIANS | Converts degrees to radians and takes the form =RADIANS(angle), where angle represents an angle measured in degrees. |
| RAND | Generates a random number between 0 and 1 and takes the form =RAND() with no arguments, but you must still enter empty parentheses after the function name. The result changes with each sheet recalculation. |
| RANDBETWEEN | Generates random integer values between a specified range of numbers and takes the form =RANDBETWEEN(bottom,top), where bottom is the smallest and top is the largest integer you want to use, inclusive. |
| ROMAN | Converts an Arabic numeral to Roman, as text, and takes the form =ROMAN(number,form), where number is the Arabic numeral you want converted and form is a number specifying the type of Roman numeral you want (1, 2, or 3 = more concise notation; 4 or FALSE = simplified notation; TRUE = classic notation). |
| ROUND | Rounds a number to a specified number of decimal places and takes the form =ROUND(number,num_digits), where number can be a number, a reference to a cell that contains a number, or a formula that results in a number. num_digits can be any positive or negative integer and determines the number of decimal places. Enter a negative num_digits to round to the left of the decimal; enter zero to round to the nearest integer. |
| ROUNDDOWN | Rounds a number down, toward zero, to a specified number of decimal places and takes the same form and arguments as ROUND. |
| ROUNDUP | Rounds a number up, away from zero, to a specified number of decimal places and takes the same form and arguments as ROUND. |
| SERIESSUM | Returns the sum of a power series based on the formula and takes the form =SERIESSUM(x,n,m,coefficients), where x is the input value to the power series; n is the initial power to which you want to raise x; m is the step by which to increase n for each term in the series; and coefficients is a set of coefficients by which each successive power of x is multiplied. The number of values in coefficients determines the number of terms in the power series. |
| SIGN | Determines the sign of a number. Returns 1 if the number is positive, zero (0) if the number is 0, and -1 if the number is negative, and takes the form =SIGN(number), where number is any real number. |
| SIN | Returns the sine of an angle. The complement of the COS function, it takes the form =SIN(number), where number is the angle in radians. |
| SINH | Returns the hyperbolic sine of a number and takes the form =SINH(number), where number is any real number. |
| SQRT | Returns a positive square root of a number and takes the form =SQRT(number). |
| SQRTPI | Returns the square root of (number * pi) and takes the form =SQRTP(number). |
| SUBTOTAL | Returns a subtotal in a list or database and takes the form =SUBTOTAL(function_num,ref1,ref2,…), where function_num is a number that specifies which function to use in calculating subtotals (1=AVERAGE, 2=COUNT, 3=COUNTA, 4=MAX, 5=MIN, 6=PRODUCT, 7=STDEV, 8=STDEVP, 9=SUM, 10=VAR, 11=VARP), and refs are 1 to 29 ranges or references for which you want the subtotal. |
| SUM | Totals a series of numbers and takes the form =SUM(num1,num2,…), where nums (max 30) can be numbers, formulas, ranges, or cell references. Ignores arguments that refer to text values, logical values, or blank cells |
| SUMIF | Tests each cell in a range before adding it to the total and takes the form =SUMIF(range,criteria,sum_range), where range is the range you want to test; criteria is the logical test to be performed on each cell; and sum_range specifies the cells to be totaled. |
| SUMIFS | Tests each cell in a range that meet multiple criteria before adding it to the total and takes the form =SUMIFS(sum_range,criteria_range,criteria,…), where criteria_range is the range you want to test; criteria is the logical test to be performed on each cell; and sum_range specifies the cells to be totaled. |
| SUMPRODUCT | Multiples the value in each cell in a specified range by the corresponding cell in another equal-sized range and then adds the results. It takes the form =SUMPRODUCT(array1,array2,array3,…) and can include up to 30 arrays. Nonnumeric entries are treated as zero. |
| SUMSQ | Returns the sum of the squares of each specified value in a specified range, takes the form =SUMQ(number1,number2,…), and takes up to 30 arguments, or a single array or array reference. |
| SUMX2MY2 | Calculates the sum of the difference of the squares of the corresponding values in x and y and takes the form =SUMX2MY2(array_x,array_y), where x and y are arrays that contain the same number of elements. |
| SUMX2PY2 | Calculates the sum of the squares of the corresponding values in x and y and takes the form =SUMX2PY2(array_x,array_y), where x and y are arrays that contain the same number of elements. |
| SUMXMY2 | Calculates the sum of the squares of the differences of the corresponding values in x and y and takes the form =SUMX2MY2(array_x,array_y), where x and y are arrays that contain the same number of elements. |
| TAN | Returns the tangent of an angle and takes the form =TAN(number), where number is the angle in radians. |
| TANH | Returns the hyperbolic tangent of a number and takes the form =TAN(number), where number is any real number. |
| TRUNC | Truncates everything to the right of the decimal point, regardless of its sign, and takes the form =TRUNC(number,num_digits). Truncates everything after the specified num_digits to the right of the decimal point. |
![Reblog this post [with Zemanta]](http://img.zemanta.com/reblog_e.png?x-id=6025dd17-ae55-49b2-8dd9-0c676a8673a0)
