# Maths & Trigonometry Functions

ABS | The absolute value or a number without its sign. |

ACOS | The arc-cosine of a number. |

ACOSH | The hyperbolic arc-cosine of a number. |

ACOT | (2013) The arc-cotangent of a number. |

ACOTH | (2013) The hyperbolic arc-cotangent of a number. |

AGGREGATE | The aggregate of values in a list, table or cell range. |

ARABIC | (2013) The number converted from roman to arabic. |

ASIN | The arc-sine of a number. |

ASINH | The hyperbolic arc-sine of a number. |

ATAN | The arc-tangent of a number. |

ATAN2 | The arc-tangent of the specified x and y co-ordinates. |

ATANH | The hyperbolic arc-tangent of a number. |

BASE | (2013) The number converted into a text representation with the given base. |

CEILING | (CEILING.MATH) The number rounded up to the nearest integer or significant figure. |

CEILING.MATH | (2013) The number rounded up to the nearest integer or significant figure (including negative). |

CEILING.PRECISE | (CEILING.MATH) The number rounded up to the nearest integer or significant figure. |

COMBIN | The number of combinations for a given number of items (without repetition). |

COMBINA | (2013) The number of combinations for a given number of items (with repetition). |

COS | The cosine of a number. |

COSH | The hyperbolic cosine of a number. |

COT | (2013) The cotangent of a number. |

COTH | (2013) The hyperbolic cotangent of a number. |

CSC | (2013) The cosecant of a number. |

CSCH | (2013) The hyperbolic cosecant of a number. |

DECIMAL | (2013) The decimal number of a text representation of a number in a given base. |

DEGREES | The number of degrees given a number of radians. |

EVEN | The number rounded up to the nearest even integer. |

EXP | The exponential number raised to a particular power. |

FACT | The factorial of a positive whole number. |

FACTDOUBLE | The double factorial of a positive whole number. |

FLOOR | (FLOOR.MATH) The number rounded down to the nearest integer or significant figure. |

FLOOR.MATH | (2013) The number rounded down to the nearest integer or significant figure (including negative). |

FLOOR.PRECISE | (FLOOR.MATH) The number rounded down to the nearest integer or significant figure. |

GCD | The greatest common divisor of two or more numbers. |

INT | The number rounded down to the nearest integer. |

ISO.CEILING | (CELING.MATH) The number rounded up to the nearest integer or significant figure (renamed). |

LCM | The least common multiple of two or more numbers. |

LN | The natural logarithm of a number. |

LOG | The logarithm of a number to any base. |

LOG10 | The logarithm of a number to the base 10. |

MDETERM | The matrix determinant of an array. |

MINVERSE | The inverse matrix of an array. |

MMULT | The matrix product of two arrays. |

MOD | The remainder after division. |

MROUND | The number rounded to the desired multiple. |

MULTINOMIAL | The multinomial of a set of numbers in a list or cell range. |

MUNIT | (2013) The unit matrix or the specified dimension. |

ODD | The number rounded up to the nearest odd integer. |

PI | The number PI (3.141592). |

POWER | The number raised to a given power. |

PRODUCT | The product of all the numbers in a list or cell range. |

QUOTIENT | The integer portion after division. |

RADIANS | The number of radians given the number of degrees. |

RAND | The random number >=0 and <1. |

RANDARRAY | (2021) The array of random numbers between 0 and 1. |

RANDBETWEEN | The random number between two specified numbers (inclusive). |

ROMAN | The text string converting a binary number to a roman numeral. |

ROUND | The number rounded to a specified number of digits. |

ROUNDDOWN | The number rounded down to the nearest integer. |

ROUNDUP | The number rounded up to the nearest integer. |

SEC | (2013) The secant of a number. |

SECH | (2013) The hyperbolic secant of a number. |

SEQUENCE | (2021) The array of sequential numbers. |

SERIESSUM | The sum of a power series based on a formula. |

SIGN | The numerical value indicating if a number is positive or negative. |

SIN | The sine of a number. |

SINH | The hyperbolic sine of a number. |

SQRT | The positive square root of a number. |

SQRTPI | The square root of a number multiplied by PI. |

SUBTOTAL | (AGGREGATE) The subtotal of values in a list, table or cell range (renamed). |

SUM | The total of the values in a list, range or array. |

SUMIF | (SUMIFS) The total of the values that satisfies one condition. |

SUMIFS | The total of the values that satisfies multiple conditions. |

SUMPRODUCT | The sum of the product of one or more arrays of values. |

SUMSQ | The sum of the squares of all the values in a list, table or cell range. |

SUMX2MY2 | The sum of the difference of squares of corresponding values in two arrays. |

SUMX2PY2 | The sum of the sum of squares of corresponding values in two arrays. |

SUMXMY2 | The sum of squares of differences of corresponding values in two arrays. |

TAN | The tangent of a number. |

TANH | The hyperbolic tangent of a number. |

TRUNC | The number with any decimal places removed. |

ABSThe absolute value or a number without its sign. |

ACOSThe arc-cosine of a number. |

ACOSHThe hyperbolic arc-cosine of a number. |

ACOT(2013) The arc-cotangent of a number. |

ACOTH(2013) The hyperbolic arc-cotangent of a number. |

AGGREGATEThe aggregate of values in a list, table or cell range. |

ARABIC(2013) The number converted from roman to arabic. |

ASINThe arc-sine of a number. |

ASINHThe hyperbolic arc-sine of a number. |

ATANThe arc-tangent of a number. |

ATAN2The arc-tangent of the specified x and y co-ordinates. |

ATANHThe hyperbolic arc-tangent of a number. |

BASE(2013) The number converted into a text representation with the given base. |

CEILING(CEILING.MATH) The number rounded up to the nearest integer or significant figure. |

CEILING.MATH(2013) The number rounded up to the nearest integer or significant figure (including negative). |

CEILING.PRECISE(CEILING.MATH) The number rounded up to the nearest integer or significant figure. |

COMBINThe number of combinations for a given number of items (without repetition). |

COMBINA(2013) The number of combinations for a given number of items (with repetition). |

COSThe cosine of a number. |

COSHThe hyperbolic cosine of a number. |

COT(2013) The cotangent of a number. |

COTH(2013) The hyperbolic cotangent of a number. |

CSC(2013) The cosecant of a number. |

CSCH(2013) The hyperbolic cosecant of a number. |

DECIMAL(2013) The decimal number of a text representation of a number in a given base. |

DEGREESThe number of degrees given a number of radians. |

EVENThe number rounded up to the nearest even integer. |

EXPThe exponential number raised to a particular power. |

FACTThe factorial of a positive whole number. |

FACTDOUBLEThe double factorial of a positive whole number. |

FLOOR(FLOOR.MATH) The number rounded down to the nearest integer or significant figure. |

FLOOR.MATH(2013) The number rounded down to the nearest integer or significant figure (including negative). |

FLOOR.PRECISE(FLOOR.MATH) The number rounded down to the nearest integer or significant figure. |

GCDThe greatest common divisor of two or more numbers. |

INTThe number rounded down to the nearest integer. |

ISO.CEILING(CELING.MATH) The number rounded up to the nearest integer or significant figure (renamed). |

LCMThe least common multiple of two or more numbers. |

LNThe natural logarithm of a number. |

LOGThe logarithm of a number to any base. |

LOG10The logarithm of a number to the base 10. |

MDETERMThe matrix determinant of an array. |

MINVERSEThe inverse matrix of an array. |

MMULTThe matrix product of two arrays. |

MODThe remainder after division. |

MROUNDThe number rounded to the desired multiple. |

MULTINOMIALThe multinomial of a set of numbers in a list or cell range. |

MUNIT(2013) The unit matrix or the specified dimension. |

ODDThe number rounded up to the nearest odd integer. |

PIThe number PI (3.141592). |

POWERThe number raised to a given power. |

PRODUCTThe product of all the numbers in a list or cell range. |

QUOTIENTThe integer portion after division. |

RADIANSThe number of radians given the number of degrees. |

RANDThe random number >=0 and <1. |

RANDARRAY(2021) The array of random numbers between 0 and 1. |

RANDBETWEENThe random number between two specified numbers (inclusive). |

ROMANThe text string converting a binary number to a roman numeral. |

ROUNDThe number rounded to a specified number of digits. |

ROUNDDOWNThe number rounded down to the nearest integer. |

ROUNDUPThe number rounded up to the nearest integer. |

SEC(2013) The secant of a number. |

SECH(2013) The hyperbolic secant of a number. |

SEQUENCE(2021) The array of sequential numbers. |

SERIESSUMThe sum of a power series based on a formula. |

SIGNThe numerical value indicating if a number is positive or negative. |

SINThe sine of a number. |

SINHThe hyperbolic sine of a number. |

SQRTThe positive square root of a number. |

SQRTPIThe square root of a number multiplied by PI. |

SUBTOTAL(AGGREGATE) The subtotal of values in a list, table or cell range (renamed). |

SUMThe total of the values in a list, range or array. |

SUMIF(SUMIFS) The total of the values that satisfies one condition. |

SUMIFSThe total of the values that satisfies multiple conditions. |

SUMPRODUCTThe sum of the product of one or more arrays of values. |

SUMSQThe sum of the squares of all the values in a list, table or cell range. |

SUMX2MY2The sum of the difference of squares of corresponding values in two arrays. |

SUMX2PY2The sum of the sum of squares of corresponding values in two arrays. |

SUMXMY2The sum of squares of differences of corresponding values in two arrays. |

TANThe tangent of a number. |

TANHThe hyperbolic tangent of a number. |

TRUNCThe number with any decimal places removed. |

© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top