Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How To Filter Data in Excel
  • How to sum a total in multiple Excel tables
  • Calculate Conditional Percentile ‘IF’ in table in Excel
  • How to Use Solver Tool in Excel
  • How to create Checklist in Excel

References

  • Find Closest Match in Excel Using INDEX, MATCH, ABS and MIN functions
  • Convert text string to valid reference in Excel using Indirect function
  • Excel Advanced Lookup using Index and Match Functions
  • Approximate match with multiple criteria in Excel
  • Get nth match with INDEX / MATCH in Excel

Data Validations

  • How To Create Drop-down List in Excel
  • Excel Data validation exists in list
  • Excel Data validation must begin with
  • Excel Data validation no punctuation
  • Excel Data validation date in specific year

Category: Math and Trig Functions

Excel Math & Trig functions perform many of the common mathematical calculations, including basic arithmetic, conditional sums & products, exponents & logarithms, and the trigonometric ratios.

CEILING.PRECISE function: Description, Usage, Syntax, Examples and Explanation

by

What is CEILING function in Excel? CEILING function is one of the Math and Trig functions in Microsoft Excel that returns a number that is rounded up to the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up. However, if the number or …

Continue Reading

EXP function: Description, Usage, Syntax, Examples and Explanation

by

What is EXP function in Excel? EXP function is one of the Math and Trig functions in Microsoft Excel that returns e raised to the power of number. The constant e equals 2.71828182845904, the base of the natural logarithm. Syntax of EXP function EXP(number) The EXP function syntax has the following arguments: Number: The exponent applied …

Continue Reading

SIN function: Description, Usage, Syntax, Examples and Explanation

by

What is SIN function in Excel? SIN function is one of the Math and Trig functions in Microsoft Excel that returns the sine of the given angle. Syntax of SIN function SIN(number) The SIN function syntax has the following arguments: Number: The angle in radians for which you want the sine. SIN formula explanation If your …

Continue Reading

ABS function: Description, Usage, Syntax, Examples and Explanation

by

What is ABS function in Excel? ABS function is one of the Math and Trig functions in Microsoft Excel that returns the absolute value of a number. The absolute value of a number is the number without its sign. Syntax of ABS function ABS(number) The ABS function syntax has the following arguments: Number: The real number …

Continue Reading

COMBIN function: Description, Usage, Syntax, Examples and Explanation

by

What is COMBIN function in Excel? COMBIN function is one of the Math and Trig functions in Microsoft Excel that returns the number of combinations for a given number of items. Use COMBIN to determine the total possible number of groups for a given number of items. Syntax of COMBIN function COMBIN(number, number_chosen) The COMBIN function …

Continue Reading

EVEN function: Description, Usage, Syntax, Examples and Explanation

by

What is EVEN function in Excel? EVEN function is one of the Math and Trig functions in Microsoft Excel that returns number rounded up to the nearest even integer. You can use this function for processing items that come in twos. For example, a packing crate accepts rows of one or two items. The crate …

Continue Reading

POWER function: Description, Usage, Syntax, Examples and Explanation

by

What is POWER function in Excel? POWER function is one of the Math and Trig functions in Microsoft Excel that returns the result of a number raised to a power. Let’s say you want to calculate an extremely small tolerance level for a machined part or the vast distance between two galaxies. To raise a …

Continue Reading

SINH function: Description, Usage, Syntax, Examples and Explanation

by

What is SINH function in Excel? SINH function is one of the Math and Trig functions in Microsoft Excel that returns the hyperbolic sine of a number. Syntax of SINH function SINH(number) The SINH function syntax has the following arguments: Number: Any real number. SINH formula explanation The formula for the hyperbolic sine is: Example of SINH …

Continue Reading

ACOS function: Description, Usage, Syntax, Examples and Explanation

by

What is ACOS function in Excel? ACOS function is one of the Math and Trig functions in Microsoft Excel that returns the arccosine, or inverse cosine, of a number. The arccosine is the angle whose cosine is number. The returned angle is given in radians in the range 0 (zero) to pi. Syntax of ACOS function ACOS(number) …

Continue Reading

COMBINA function: Description, Usage, Syntax, Examples and Explanation

by

What is COMBINA function in Excel? COMBINA function is one of the Math and Trig functions in Microsoft Excel that returns the number of combinations (with repetitions) for a given number of items. Syntax of COMBINA function COMBINA(number, number_chosen) The COMBINA function syntax has the following arguments. Number: Must be greater than or equal to 0, …

Continue Reading

DEGREES function: Description, Usage, Syntax, Examples and Explanation

by

What is DEGREES function in Excel? DEGREES function is one of the Math and Trig functions in Microsoft Excel that converts radians into degrees. Syntax of DEGREES function DEGREES(angle) The DEGREES function syntax has the following arguments: Angle: The angle in radians that you want to convert. Example of DEGREES function Steps to follow: 1. Open a …

Continue Reading

PRODUCT function: Description, Usage, Syntax, Examples and Explanation

by

What is PRODUCT function in Excel? PRODUCT function is one of the Math and Trig functions in Microsoft Excel that multiplies all the numbers given as arguments and returns the product. For example, if cells A1 and A2 contain numbers, you can use the formula =PRODUCT(A1, A2) to multiply those two numbers together. You can also perform …

Continue Reading

SQRT function: Description, Usage, Syntax, Examples and Explanation

by

What is SQRT function in Excel? SQRT function is one of the Math and Trig functions in Microsoft Excel that returns a positive square root. Syntax of SQRT function SQRT(number) The SQRT function syntax has the following arguments: Number: The number for which you want the square root. SQRT formula explanation If number is negative, SQRT …

Continue Reading

ACOSH function: Description, Usage, Syntax, Examples and Explanation

by

What is ACOSH function in Excel? ACOSH function is one of the Math and Trig functions in Microsoft Excel that returns the inverse hyperbolic cosine of a number. The number must be greater than or equal to 1. The inverse hyperbolic cosine is the value whose hyperbolic cosine is number, so ACOSH(COSH(number)) equals number. Syntax of ACOSH function …

Continue Reading

COS function: Description, Usage, Syntax, Examples and Explanation

by

What is COS function in Excel? COS function is one of the Math and Trig functions in Microsoft Excel that returns the cosine of the given angle. Syntax of COS function COS(number) The COS function syntax has the following arguments: Number: The angle in radians for which you want the cosine. COS formula explanation If the …

Continue Reading

INT function: Description, Usage, Syntax, Examples and Explanation

by

What is INT function in Excel? INT function is one of the Math and Trig functions in Microsoft Excel that rounds a number down to the nearest integer. Syntax of INT function INT(number) The INT function syntax has the following arguments: Number: The real number you want to round down to an integer. Example of INT function …

Continue Reading

QUOTIENT function: Description, Usage, Syntax, Examples and Explanation

by

What is QUOTIENT function in Excel? QUOTIENT function is one of the Math and Trig functions in Microsoft Excel that returns the integer portion of a division. Use this function when you want to discard the remainder of a division. Tip: If you want to divide numeric values, you should use the “/” operator as there …

Continue Reading

SQRTPI function: Description, Usage, Syntax, Examples and Explanation

by

What is SQRTPI function in Excel? SQRTPI function is one of the Math and Trig functions in Microsoft Excel that returns the square root of (number * pi). Syntax of SQRTPI function SQRTPI(number) The SQRTPI function syntax has the following arguments: Number: The number by which pi is multiplied. SQRTPI formula explanation If number < 0, …

Continue Reading

ACOT function: Description, Usage, Syntax, Examples and Explanation

by

What is ACOT function in Excel? ACOT function is one of the Math and Trig functions in Microsoft Excel that returns the principal value of the arccotangent, or inverse cotangent, of a number. Syntax of ACOT function ACOT(number) The ACOT function syntax has the following arguments. Number: Number is the cotangent of the angle you want. This …

Continue Reading

COSH function: Description, Usage, Syntax, Examples and Explanation

by

What is COSH function in Excel? COSH function is one of the Maths and Trig functions in Microsoft Excel that returns the hyperbolic cosine of a number. Syntax of COSH function COSH(number) The COSH function syntax has the following arguments: Number: Any real number for which you want to find the hyperbolic cosine. COSH formula explanation …

Continue Reading

GCD function: Description, Usage, Syntax, Examples and Explanation

by

What is GCD function in Excel? GCD function is one of the Math and Trig functions in Microsoft Excel that returns the greatest common divisor of two or more integers. The greatest common divisor is the largest integer that divides both number1 and number2 without a remainder. Syntax of GCD function GCD(number1, [number2], …) The GCD …

Continue Reading

RADIANS function: Description, Usage, Syntax, Examples and Explanation

by

What is RADIANS function in Excel? RADIANS function is one of the Math and Trig functions in Microsoft Excel that converts degrees to radians. Syntax of RADIANS function RADIANS(angle) The RADIANS function syntax has the following arguments: Angle: An angle in degrees that you want to convert. Example of RADIANS function Steps to follow: 1. Open a …

Continue Reading

SUMX2PY2 function: Description, Usage, Syntax, Examples and Explanation

by

What is SUMX2PY2 function in Excel? SUMX2PY2 function is one of the Math and Trig functions in Microsoft Excel that returns the sum of the sum of squares of corresponding values in two arrays. The sum of the sum of squares is a common term in many statistical calculations. Syntax of SUMX2PY2 function SUMX2PY2(array_x, array_y) The …

Continue Reading

ACOTH function: Description, Usage, Syntax, Examples and Explanation

by

What is ACOTH function in Excel? ACOTH function is one of the Math and Trig functions in Microsoft Excel that returns the inverse hyperbolic cotangent of a number. Syntax of ACOTH function ACOTH(number) The ACOTH function syntax has the following arguments. Number: The absolute value of Number must be greater than 1. ACOTH formula explanation The …

Continue Reading

COT function: Description, Usage, Syntax, Examples and Explanation

by

What is COT function in Excel? COT function is one of the Math and Trig functions in Microsoft Excel that return the cotangent of an angle specified in radians. Syntax of COT function COT(number) The COT function syntax has the following arguments. Number: The angle in radians for which you want the cotangent. COT formula explantion …

Continue Reading

LCM function: Description, Usage, Syntax, Examples and Explanation

by

What is LCM function in Excel? LCM function is one of the Math and Trig functions in Microsoft Excel that returns the least common multiple of integers. The least common multiple is the smallest positive integer that is a multiple of all integer arguments number1, number2, and so on. Use LCM to add fractions with …

Continue Reading

RAND function: Description, Usage, Syntax, Examples and Explanation

by

What is RAND function in Excel? RAND function is one of the Math and Trig functions in Microsoft Excel that returns an evenly distributed random real number greater than or equal to 0 and less than 1. A new random real number is returned every time the worksheet is calculated. Syntax of RAND function RAND() The …

Continue Reading

SUMXMY2 function: Description, Usage, Syntax, Examples and Explanation

by

What is SUMXMY2 function in Excel? SUMXMY2 function is one of the Math and Trig functions in Microsoft Excel that returns the sum of squares of differences of corresponding values in two arrays. Syntax of SUMXMY2 function SUMXMY2(array_x, array_y) The SUMXMY2 function syntax has the following arguments: Array_x: The first array or range of values. Array_y:  …

Continue Reading

AGGREGATE function: Description, Usage, Syntax, Examples and Explanation

by

What is AGGREGATE function in Excel? AGGREGATE function is one of the Math and Trig functions in Microsoft Excel that returns an aggregate in a list or database. The AGGREGATE function can apply different aggregate functions to a list or database with the option to ignore hidden rows and error values. Syntax of AGGREGATE function Reference …

Continue Reading

COTH function: Description, Usage, Syntax, Examples and Explanation

by

What is COTH function in Excel? COTH function is one of the Math and Trig functions in Microsoft Excel that return the hyperbolic cotangent of a hyperbolic angle. Syntax of COTH function COTH(number) The COTH function syntax has the following arguments. Number COTH formula explanation The hyperbolic cotangent is an analog of the ordinary (circular) cotangent. …

Continue Reading

LN function: Description, Usage, Syntax, Examples and Explanation

by

What is LN function in Excel? LN function is one of the Math and Trig functions in Microsoft Excel that returns the natural logarithm of a number. Natural logarithms are based on the constant e (2.71828182845904). Syntax of LN function LN(number) The LN function syntax has the following arguments: Number: The positive real number for which …

Continue Reading

RANDBETWEEN function: Description, Usage, Syntax, Examples and Explanation

by

What is RANDBETWEEN function in Excel? RANDBETWEEN function is one of the Math and Trig functions in Microsoft Excel that returns a random integer number between the numbers you specify. A new random integer number is returned every time the worksheet is calculated. Syntax of RANDBETWEEN function RANDBETWEEN(bottom, top) The RANDBETWEEN function syntax has the following …

Continue Reading

TAN function: Description, Usage, Syntax, Examples and Explanation

by

What is TAN function in Excel? TAN function is one of the Math and Trig functions in Microsoft Excel that returns the tangent of the given angle. Syntax of TAN function TAN(number) The TAN function syntax has the following arguments: Number: The angle in radians for which you want the tangent. TAN formula explanation If your …

Continue Reading

ARABIC function: Description, Usage, Syntax, Examples and Explanation

by

What is ARABIC function in Excel? ARABIC function is one of the Math and Trig functions in Microsoft Excel that converts a Roman numeral to an Arabic numeral. Syntax of ARABIC function ARABIC( text ) The ARABIC function syntax has the following arguments. Text: A string enclosed in quotation marks, an empty string (“”), or a …

Continue Reading

CSC function: Description, Usage, Syntax, Examples and Explanation

by

What is CSC function in Excel? CSC function is one of the Math and Trig functions in Microsoft Excel that returns the cosecant of an angle specified in radians. Syntax of CSC function CSC(number) The CSC function syntax has the following arguments. Number CSC formula explanation The absolute value of Number must be less than 2^27. …

Continue Reading

LOG function: Description, Usage, Syntax, Examples and Explanation

by

What is LOG function in Excel? LOG function is one of the Math and Trig functions in Microsoft Excel that returns the logarithm of a number to the base you specify. Syntax of LOG function LOG(number, [base]) The LOG function syntax has the following arguments: Number: The positive real number for which you want the logarithm. …

Continue Reading

ROMAN function: Description, Usage, Syntax, Examples and Explanation

by

What is ROMAN function in Excel? ROMAN function is one of the Math and Trig functions in Microsoft Excel that converts an arabic numeral to roman, as text. Syntax of ROMAN function ROMAN(number, [form]) The ROMAN function syntax has the following arguments: Number: The Arabic numeral you want converted. Form(Optional): A number specifying the type of …

Continue Reading

TANH function: Description, Usage, Syntax, Examples and Explanation

by

What is TANH function in Excel? TANH function is one of the Math and Trig functions in Microsoft Excel that returns the hyperbolic tangent of a number. Syntax of TANH function TANH(number) The TANH function syntax has the following arguments: Number: Any real number. TANH formula explanation The formula for the hyperbolic tangent is: Example of TANH …

Continue Reading

ASIN function: Description, Usage, Syntax, Examples and Explanation

by

What is ASIN function in Excel? ASIN function is one of the Math and Trig functions in Microsoft Excel that returns the arcsine, or inverse sine, of a number. The arcsine is the angle whose sine is number. The returned angle is given in radians in the range -pi/2 to pi/2. Syntax of ASIN function ASIN(number) The …

Continue Reading

CSCH function: Description, Usage, Syntax, Examples and Explanation

by

What is CSCH function in Excel? CSCH function is one of the Math and Trig functions in Microsoft Excel that return the hyperbolic cosecant of an angle specified in radians. Syntax of CSCH function CSCH(number) The CSCH function syntax has the following arguments. Number CSCH formula explanation The absolute value of Number must be less than …

Continue Reading

Posts navigation

  • Previous
  • 1
  • 2
  • 3
  • 4
  • Next

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • Complete List of Excel Logical Functions, References and Examples
  • How to return blank in place of #DIV/0! error in Excel
  • AND function: Description, Usage, Syntax, Examples and Explanation
  • IFS function: Description, Usage, Syntax, Examples and Explanation
  • Check multiple cells are equal in Excel

Date Time

  • Get work hours between dates custom schedule in Excel
  • Generate series of dates by weekends in Excel
  • DAYS360 function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate months between dates in Excel
  • Add days to date in Excel

Grouping

  • Group times into 3 hour buckets in Excel
  • If cell contains one of many things in Excel
  • Map inputs to arbitrary values in Excel
  • Categorize text with keywords in Excel
  • Running count group by n size in Excel

General

  • 3D SUMIF for multiple worksheets in Excel
  • Mark Workbook as Final in Excel
  • Sum by group in Excel
  • How to calculate percent change in Excel
  • How to create dynamic worksheet reference in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning