The SUMIF Function
It returns the sum of all the cells in a given range that meet a specific criterion.
0305, 2019
Tag Archives: Math
0305, 2019
The SUMPRODUCT Function
It returns a number rounded down, to the nearest integer .
0305, 2019
The PRODUCT Function
It multiplies all the numbers given to it as arguments and returns the product.
0305, 2019
The INT Function
It returns a number rounded down, to the nearest integer .
0305, 2019
The FLOOR.MATH Function
It returns a number rounded down, to the nearest integer or to the nearest multiple of significance. Its syntax and usage is similar to the FLOOR function.
0305, 2019
The FLOOR Function
It returns a number rounded down, toward zero, to the nearest multiple of significance .
0305, 2019
The CEILING.MATH Function
It returns a number rounded up, to the nearest integer or to the nearest multiple of significance. Its syntax and usage is similar to the CEILING function.
0305, 2019
The CEILING Function
It returns a number rounded up, away from zero, to the nearest multiple of significance .
1904, 2019
The PI Function
It returns the number 3.14159265358979, the mathematical constant pi, accurate to 15 digits.
1904, 2019
The MROUND Function
It rounds a number to a specific multiple.
