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

Data Analysis

  • Data Series in Excel
  • What-If Analysis: Scenarios and Goal Seek in Excel
  • Working With Tables in Excel
  • Reverse List in Excel
  • How to create dynamic reference table name in Excel

References

  • How to use Excel COLUMN Function
  • Create hyperlink with VLOOKUP in Excel
  • Approximate match with multiple criteria in Excel
  • How to get relative column numbers in a range in Excel
  • Count unique text values with criteria

Data Validations

  • Excel Data validation don’t exceed total
  • Excel Data validation number multiple 100
  • Excel Data validation must not contain
  • Excel Data validation must begin with
  • Excel Data validation whole percentage only

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.

SUMIF function in Excel

by

The powerful SUMIF function in Excel sums cells based on one criteria. This page contains many easy to follow SUMIF examples. Numbers 1. The SUMIF function below (two arguments) sums values in the range A1:A5 that are less than or equal to 10. 2. The following SUMIF function gives the exact same result. It uses the & operator to …

Continue Reading

RAND vs RANDBETWEEN function examples in Excel

by

Excel has two useful functions when it comes to generating random numbers. The RAND and RANDBETWEEN function. Rand The RAND function generates a random decimal number between 0 and 1. 1. Select cell A1. 2. Type RAND() and press Enter. The RAND function has no arguments. 3. To generate a list of random numbers, select cell A1, click on …

Continue Reading

Count and Sum Functions in Excel

by

The most used functions in Excel are the functions that count and sum. COUNT function is one of the STATISTICAL functions while SUM function is one of the Math and Trig functions. You can count and sum based on one criteria or multiple criteria. Count To count the number of cells that contain numbers, use the COUNT function. Countif To count cells …

Continue Reading

Round numbers in Excel

by

This chapter illustrates three Mathematical functions ROUND, ROUNDUP and ROUNDDOWN. Navigation: Formula Tab → Function Library Group → Math & Trig Category Before your start: if you round a number, you lose precision. If you don’t want this, show fewer decimal places without changing the number itself. Round Syntax: ROUND(number, num_digits) 1. Round a number to two decimal places. …

Continue Reading

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

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

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

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

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

Logical Functions

  • FALSE function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel FALSE Function
  • AND function: Description, Usage, Syntax, Examples and Explanation
  • IF with boolean logic in Excel
  • Return blank if in Excel

Date Time

  • WEEKNUM function: Description, Usage, Syntax, Examples and Explanation
  • Add decimal hours to time in Excel
  • Convert date to text in Excel
  • Calculate years between dates in Excel
  • How to calculate workdays per month in Excel

Grouping

  • Group times into unequal buckets in Excel
  • Group numbers with VLOOKUP in Excel
  • If cell contains one of many things in Excel
  • Categorize text with keywords in Excel
  • How to randomly assign data to groups in Excel

General

  • Share Excel data with Word documents
  • Flash Fill in Excel
  • Delete Blank Rows at Once in Excel
  • Common Errors in Excel
  • How to generate random number between two numbers in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning