The Excel PI function returns the value of the geometric constant π (pi). The value represents a half-rotation in the radian angle system. The constant appears in many formulas relating the circle, such as the area of a circle. Syntax […]
Read more →
The Excel SQRT function returns the square root of a positive number. Syntax The syntax for the SQRT function in Microsoft Excel is: =SQRT( number ) Parameters or Arguments number A positive number that you wish to return the square […]
Read more →
The Excel POWER function returns a number to a given power. The POWER function works like an exponent in a standard math equation. Syntax The syntax for the POWER function in Microsoft Excel is: =POWER( number, power ) Parameters or […]
Read more →
The Excel Sumproduct function returns the sum of the products of corresponding ranges or arrays. But this function is capable of much more than its definition. Syntax The syntax for the Sumproduct function in Microsoft Excel is: SUMPRODUCT( array1, […]
Read more →
The Excel Sumsq function returns the sum of squares of a supplied set of values. Syntax The syntax for the SUMSQ function in Microsoft Excel is: =SUMSQ( value1, [value2, … value_n] ) Parameters or Arguments value1, value2, … value_n A […]
Read more →
SUMIFS is a function to sum cells that meet multiple criteria. SUMIFS can be used to sum values when adjacent cells meet criteria based on dates, numbers, and text. SUMIFS supports logical operators (>,<,<>,=) and wildcards (*,?) for partial matching. […]
Read more →
SUMIF is a function to sum cells that meet a single criteria. SUMIF can be used to sum cells based on dates, numbers, and text that match specific criteria. SUMIF supports logical operators (>,<,<>,=) and wildcards (*,?) for partial matching. […]
Read more →
The Excel EVEN function returns the next even integer after rounding a given number up. The EVEN function always rounds numbers up (away from zero) so positive numbers become larger and negative numbers become smaller (i.e. more negative). Syntax The […]
Read more →
The Excel ODD function returns the next odd integer after rounding a given number up. The ODD function always rounds numbers up (away from zero) so positive numbers become larger and negative numbers become smaller (i.e. more negative). Syntax The […]
Read more →
The Excel LCM function returns the least common multiple of integers. The least common multiple is the smallest positive integer that is a multiple of all supplied numbers. Syntax The Syntax for the LCM Formula is: =LCM(number1,number2) Function Arguments number1 […]
Read more →