MATH Articles: Excel and Google Sheets

EVEN is a function in Excel that rounds up a number to the nearest even integer.  This step by step tutorial will assist all levels of Excel users in using the EVEN function.   Figure 1. Final result: Excel EVEN function Syntax of the EVEN Function =EVEN(number) number - the...

While working with Excel, we are able to sum values based on one or more criteria by using the SUMIFS function.  This step by step tutorial will assist all levels of Excel users in the usage and syntax of SUMIFS function. Figure 1. Final result: Excel SUMIFS function Final formula...

Excel allows us to calculate the logarithm of a number for a given base, by using the LOG function. This step by step tutorial will assist all levels of Excel users in getting the logarithm for a number Figure 1. The result of the LOG function Syntax of the LOG...

Excel allows us to get an absolute value of a number, by using the ABS function. The ABS function converts a negative number to a positive This step by step tutorial will assist all levels of Excel users in getting an absolute value of a number. Figure 1. The result...

GCD function stands for Greatest Common Divisor. this function allows us to get the greatest divisor which is common for two or more numbers. It is the largest integer that can divide all the given numbers of a database without reminders. In this tutorial, we will learn how to use...

We can find the TANGENT of an angle by using the TAN function and the RADIANS function. This can also be done by using the TAN and PI function. Figure 1: Result of the TAN function for 30, 45, and 60 degrees Using the TAN and RADIANS function The TAN...

Excel helps its users offering some great solutions for arithmetic operations. SUMPRODUCT is one such function. It multiplies ranges or arrays and returns the product sums.We can nest other functions inside the SUMPRODUCT function to enhance its ability. In this tutorial, we will learn how to use the SUMPRODUCT function...

We can sum entire columns in Excel using the SUM function. The SUM function takes numbers and sums them up. In this tutorial, we will learn how to add a whole column in Excel using the SUM function. Figure 1. Example of How to Sum Entire Column in Excel Syntax...