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

Data Analysis

  • How to combine 2 or more chart types in a single chart in Excel
  • How To Remove Duplicates In Excel Column Or Row?
  • Filter Data Based on Date in Excel
  • Error Bars in Excel
  • How To Sort One Column or Multiple Columns in Excel

References

  • How to get last row in numeric data in Excel
  • Merge tables with VLOOKUP in Excel
  • Count rows that contain specific values in Excel
  • How to get address of last cell in range in Excel
  • How to create dynamic named range with OFFSET in Excel

Data Validations

  • Excel Data validation with conditional list
  • Prevent invalid data entering in specific cells
  • Excel Data validation must not contain
  • How To Create Drop-down List in Excel
  • Excel Data validation allow weekday 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.

Calculate Weighted Average in Excel

by

To calculate a weighted average in Excel, simply use the SUMPRODUCT and the SUM function. 1. The AVERAGE function below calculates the normal average of three scores. Suppose your teacher says, “The test counts twice as much as the quiz and the final exam counts three times as much as the quiz”. 2. Below you can find the …

Continue Reading

Use of INT and TRUNC function in Excel

by

This example illustrates two functions to chop off decimals in Excel. The INT and the TRUNC function. Int The INT (Integer) function rounds a number down to the nearest integer. Conclusion: the INT function only chops off decimals from positive numbers. Trunc Truncate a number to a given precision. The TRUNC (Truncate) function always chops off decimals. The TRUNC function can keep …

Continue Reading

Excel MROUND, CEILING and FLOOR function examples

by

Find Nearest Multiple in Excel This example illustrates three functions to round numbers to a multiple of x in Excel. The MROUND, CEILING and the FLOOR function. Mround 1. For example, round a number to the nearest multiple of 10. 2. For example, round a number to the nearest multiple of 5. Ceiling The same as MROUND but rounds up. Floor The same as …

Continue Reading

Even and Odd function in Excel

by

This example illustrates the EVEN and the ODD function in Excel. It also shows you how to determine if a number is even or odd. Even 1. Rounds a positive number up to the nearest even integer. 2. Rounds a negative number down to the nearest even integer. Odd 1. Rounds a positive number up to the nearest odd integer. …

Continue Reading

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

How to create Roll the Dice in Excel

by

This example teaches you how to simulate the roll of two dice in Excel. Note: the instructions below do not teach you how to format the worksheet. We assume that you know how to change font sizes, font styles, insert rows and columns, add borders, change background colors, etc. 1. At the moment, each cell contains …

Continue Reading

Excel ABS function Example

by

The ABS function in Excel returns the absolute value of a number. In other words: the ABS function removes the minus sign (-) from a negative number, making it positive. 1. For example, the ABS function in cell B1 below returns the absolute value of a negative number. The ABS function has no effect on 0 (zero) or positive …

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

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

  • 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

  • Invoice status with nested if in Excel
  • How to use Excel OR Function
  • IF function: Description, Usage, Syntax, Examples and Explanation
  • OR function Examples in Excel
  • IFERROR function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • Convert text to date in Excel
  • Add decimal hours to time in Excel
  • Convert decimal minutes to Excel time
  • Add workdays to date custom weekends in Excel
  • How to get Holiday Date from Year in Excel

Grouping

  • How to randomly assign data to groups in Excel
  • If cell contains one of many things in Excel
  • Running count group by n size in Excel
  • Group times into unequal buckets in Excel
  • Map text to numbers in Excel

General

  • How to choose page/paper size in Excel before Printing
  • Subtotal invoices by age in Excel
  • How to calculate profit margin percentage in Excel
  • Find, Select, Replace and Go To Special in Excel
  • How to generate random number weighted probability in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning