This section will learn how to use Excel’s Date And Time Functions such as: ABS, ACOS, ACOSH, Aggregate, ASIN, ASINH, etc.
ABS – returns the absolute value of a number
ACOS – returns the arccosine value of a number
ACOSH – returns the inverse hyperbolic cosine of a number
AGGREGATE – returns an aggregate in a list or database and ignore errors or hidden rows.it allow you to apply functions such as: SUM, COUNT, MAX, MIN, SMALL and etc.
ASIN – returns the arcsine value of a number
ASINH – returns the inverse hyperbolic sine of a number.
ATAN -returns the arctangent of a number.
ATAN2 – returns the arctangent, or inverse tangent, of the specified x- and y-coordinates.
ATANH – returns the inverse hyperbolic tangent of a given number.
CEILING – returns a given number rounded up to the nearest multiple of a given number of significance.
CEILING.PRECISE – returns a given number rounded up to the nearest multiple of a given number of significance or returns a number that is rounded up to the nearest integer number.
COMBIN – returns the number of combinations for a given number of items.
COMBINA – returns the number of combinations for a given number of items and it includes repetitions.
COS – returns the cosine of a given angle.
COSH – returns the hyperbolic cosine of a given angle.
DEGREES – converts radians into degrees. And it will return a numeric value.
EVEN – rounds a given number up to the nearest even integer.
EXP – returns e raised to the power of a number.
FACT – returns the factorial of a given number.
FLOOR – returns a number rounded down to the nearest multiple of significance.
INT – returns the integer portion of a given number.
LN – returns the natural logarithm of a given number.
LOG – returns the logarithm of a given number based on a supplied base.
LOG10 – returns the base-10 logarithm of a given number.
MDETERM – returns the matrix determinant of an array.
MINVERSE – returns the inverse matrix for a given matrix.
MMULT – returns the matrix product of two arrays.
MOD – returns the remainder of two numbers after division.
ODD – rounds a given number up to the nearest odd integer.
PI – returns the value of mathematical constant PI.
POWER – returns the result of a number raised to a given power.
PRODUCT – multiplies the numbers and returns the product.
RADIANS – converts degrees into radians in Excel.
RAND – returns a random real number that is greater than or equal to 0 and less than 1.
RANDBETWEEN – returns a random integer number that is between the numbers you specify.
ROMAN – converts an arabic numeral to roman and the format is Text for returned value.
ROUND – rounds a number to a specified number of digits.
ROUNDDOWN – round the number down to the specified number of digits.
ROUNDUP – rounds the number up to a specified number of decimal places.
SIGN – returns the sign of a number.
SIN – returns the hyperbolic tangent of a given number.
SINH – returns the hyperbolic sine of a number.
SQRT – returns the square root of a positive number.
SUBTOTAL – returns the subtotal of the numbers in a list or database
SIN – returns the sine of a given angle.
SUM – adds all numbers in a range of cells and returns the sum of these values.
SUMIF – sum the numbers in the range of cells that meet a single criteria that you specify.
SUMIFS – sum the numbers in the range of cells that meet a single or multiple criteria that you specify.
SUMPRODUCT – multiplies corresponding components in the given one or more arrays or ranges, and returns the sum of those products.
SUMSQ – returns the sum of squares of a given set of arguments.
SUMX2MY2 – returns the sum of the difference of squares between two supplied arrays.
SUMXMY2 – returns the sum of the squares of differences between corresponding values in two given arrays and then return the sum of the result.
SUMX2PY2 -returns the sum of the sum of squares of corresponding items in two supplied arrays.
TAN – returns the tangent of a given angle.
TANH -returns the hyperbolic tangent of a given number.
TRUNC– truncates a number to an integer by removing the fractional part of the number.
Leave a Reply
You must be logged in to post a comment.