Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to reference named range different sheet in Excel
  • Extract all partial matches in Excel
  • Count rows that contain specific values in Excel
  • How to use Excel ROWS Function
  • Perform case-sensitive Lookup in Excel

Data Analysis Examples

  • Get column name from index in Excel Table
  • How to add Trendline to a chart in Excel
  • Excel Bar Chart
  • Filter Data Based on Date in Excel
  • Randomize/ Shuffle List in Excel

Data Validation Examples

  • Excel Data validation specific characters only
  • Excel Data validation allow weekday only
  • Excel Data validation only dates between
  • Excel Data validation must contain specific text
  • Excel Data validation exists in list

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.

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

by

Examples of MINVERSE function Example 1 Steps to follow: 1. Open a new Excel worksheet. 2. Copy data in the following table below and paste it in cell A1 Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter. You can adjust the column widths to see all …

Continue Reading

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

by

Example of PI function Steps to follow: 1. Open a new Excel worksheet. 2. Copy data in the following table below and paste it in cell A1 Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter. You can adjust the column widths to see all the data, …

Continue Reading

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

by

What is MUNIT function in Excel? MUNIT function is one of the Math and Trig functions in Microsoft Excel that returns the unit matrix for the specified dimension. Syntax of MUNIT function MUNIT(dimension) The MUNIT function syntax has the following arguments. Dimension: Dimension is an integer specifying the dimension of the unit matrix that you want …

Continue Reading

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

by

What is MOD function in Excel? MOD function is one of the Math and Trig functions in Microsoft Excel that returns the remainder after number is divided by divisor. The result has the same sign as divisor. Syntax of MOD function MOD(number, divisor) The MOD function syntax has the following arguments: Number: The number for which …

Continue Reading

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

by

What is MULTINOMIAL function in Excel? MULTINOMIAL function is one of the Math and Trig functions in Microsoft Excel that returns the ratio of the factorial of a sum of values to the product of factorials. Syntax of MULTINOMIAL function MULTINOMIAL(number1, [number2], …) The MULTINOMIAL function syntax has the following arguments: Number1, number2, …    Number1 is required, …

Continue Reading

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

by

What is MROUND function in Excel? MROUND function is one of the Math and Trig functions in Microsoft Excel that returns a number rounded to the desired multiple. Syntax of MROUND function MROUND(number, multiple) The MROUND function syntax has the following arguments: Number: The value to round. Multiple: The multiple to which you want to round …

Continue Reading

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

by

What is ODD function in Excel? ODD function is one of the Math and Trig functions in Microsoft Excel that returns number rounded up to the nearest odd integer. Syntax of ODD function ODD(number) The ODD function syntax has the following arguments: Number: The value to round. ODD formula explanation If number is nonnumeric, ODD returns …

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

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

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

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

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

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

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

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

by

What is ROUND function in Excel? ROUND function is one of the Math and Trig functions in Microsoft Excel that rounds a number to a specified number of digits. For example, if cell A1 contains 23.7825, and you want to round that value to two decimal places, you can use the following formula: =ROUND(A1, 2) …

Continue Reading

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

by

What is ROUNDDOWN function in Excel? ROUNDDOWN function is one of the Math and Trig functions in Microsoft Excel that rounds a number down, toward zero. Syntax of ROUNDDOWN function ROUNDDOWN(number, num_digits) The ROUNDDOWN function syntax has the following arguments: Number: Any real number that you want rounded down. Num_digits: The number of digits to which you …

Continue Reading

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

by

What is ROUNDUP function in Excel? ROUNDUP function is one of the Math and Trig functions in Microsoft Excel that rounds a number up, away from 0 (zero). Syntax of ROUNDUP function ROUNDUP(number, num_digits) The ROUNDUP function syntax has the following arguments: Number: Any real number that you want rounded up. Num_digits: The number of digits …

Continue Reading

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

by

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

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

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

by

What is SEQUENCE function in Excel? SEQUENCE function is one of the Math and Trig functions in Microsoft Excel that allows you to generate a list of sequential numbers in an array, such as 1, 2, 3, 4. Syntax of SEQUENCE function =SEQUENCE(rows, [columns], [start], [step]) SEQUENCE(number of row, number of columns,starting number, step size) …

Continue Reading

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

by

What is SUMIF function in Excel? SUMIF function is one of the Math and Trig functions in Microsoft Excel that is used to sum the values in a range that meet criteria that you specify. For example, suppose that in a column that contains numbers, you want to sum only the values that are larger …

Continue Reading

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

by

What is SUMIFS function in Excel? SUMIFS function is one of the Math and Trig functions in Microsoft Excel that adds all of its arguments that meet multiple criteria. For example, you would use SUMIFS to sum the number of retailers in the country who (1) reside in a single zip code and (2) whose …

Continue Reading

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

by

What is SUMSQ function in Excel? SUMSQ function is one of the Math and Trig functions in Microsoft Excel that multiplies corresponding components in the given arrays, and returns the sum of those products. Syntax of SUMSQ function SUMPRODUCT(array1, [array2], [array3], …) The SUMPRODUCT function syntax has the following arguments: Array1     Required. The first array argument …

Continue Reading

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

by

What is SUMSQ function in Excel? SUMSQ function is one of the Math and Trig functions in Microsoft Excel that returns the sum of the squares of the arguments. Syntax of SUMSQ function SUMSQ(number1, [number2], …) The SUMSQ function syntax has the following arguments: Number1, number2, …    Number1 is required, subsequent numbers are optional. 1 to 255 …

Continue Reading

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

by

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

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

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

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

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

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

by

What is MMULT function in Excel? MMULT function is one of the Math and Trig functions in Microsoft Excel that returns the matrix product of two arrays. The result is an array with the same number of rows as array1 and the same number of columns as array2. Syntax of MMULT function MMULT(array1, array2) The MMULT …

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

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

by

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

Continue Reading

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

by

What is SERIESSUM function in Excel? SERIESSUM function is one of the Math and Trig functions in Microsoft Excel that returns the sum of a power series based on the formula: Many functions can be approximated by a power series expansion. Syntax of SERIESSUM function SERIESSUM(x, n, m, coefficients) The SERIESSUM function syntax has the following …

Continue Reading

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

by

What is SIGN function in Excel? SIGN function is one of the Math and Trig functions in Microsoft Excel that 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. Syntax of SIGN function SIGN(number) The SIGN function syntax …

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

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

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

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

by

What is SUBTOTAL function in Excel? SUBTOTAL function is one of the Math and Trig functions in Microsoft Excel that returns a subtotal in a list or database. It is generally easier to create a list with subtotals by using the Subtotal command in the Outline group on the Data tab in the Excel desktop application. Once the subtotal list is …

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

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

Posts navigation

  • 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
  • LOWER function: Description, Usage, Syntax, Examples and Explanation
  • How to remove trailing slash from url in Excel
  • Split numbers from units of measure in Excel
  • How to get page from URL in Excel
  • Split dimensions into two parts in Excel Worksheet
  • MINUTE function: Description, Usage, Syntax, Examples and Explanation
  • Get last weekday in month in Excel
  • Convert decimal seconds to Excel time
  • How to calculate nth day of week in month in Excel
  • Basic timesheet formula with breaks in Excel
  • How to calculate annual compound interest schedule in Excel
  • How to calculate annuity for interest rate in excel
  • Calculate cumulative loan principal payments in Excel
  • INTRATE function: Description, Usage, Syntax, Examples and Explanation
  • FV function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2022 xlsoffice . All Right Reserved. | Teal Smiles