MATH Articles: Excel and Google Sheets

Microsoft Excel is widely acknowledged for its versatility. It is commonly used for sorting out lists of numeric, text strings, alphanumeric, email, postal addresses, ZIP Codes, and so on. However, it also comprises of a unique and simple option which enable its users to convert regular whole numbers into ROMAN...

We can use the excel RANDBETWEEN function to generate random numbers in excel. The steps below will walk through the process. Figure 1: Result of RANDBETWEEN function for Cells of Column D General Formula =RANDBETWEEN(bottom,top) Bottom – This is the smallest random integer that will be returned by the RANDBETWEEN...

We can use the excel SUMIF function to add numbers in a range of cells based on a criteria. The steps below will walk through the process. Figure 1: How to Use the Excel SUMIF Function General Formula =SUMIF(range,criteria,[sum_range]) Formula =SUMIF(A4:A11,"<5/1/2019",B4:B11) Setting up the Data We will set up the...

Excel LN Function Figure 1.  Using the Ln Function Generic Formula LN(number) Explanation The Excel LN function returns the result as the natural logarithm of the numeric value entered in the cell. The LN function is an inbuilt function in Microsoft Excel that is categorized as a Math/Trig Function. It...

Excel allows a user to get a result of division without a remainder using the QUOTIENT function. This step by step tutorial will assist all levels of Excel users in dividing without a remainder. We will also cover the common errors experienced while using the function. Figure 1. The result...

The Excel SIN function calculates the sine of a given angle. The syntax is as follows: SIN(value) The value argument of this function is the angle —expressed in radians— of which we want to compute for the sine. Sine of an Angle As a refresher to the concept of sine,...

Excel EXP Function Want to learn more about how to returns e raised to the power of number by using an excel spreadsheet?? This post will give you an overview of how to use EXP formula functions to returns the result of the constant e raised to the power of...

Cosine is one of the basic functions in Trigonometry and manual calculations are generally hard to perform.  Excel provides an easy way of calculating the cosine through the COS function.  This tutorial will assist all levels of Excel users in the usage and syntax of COS function.   Figure 1....

Excel allows us to get a random decimal number between 0 and 1 by using the RAND function. We will also see how to make the function to return a number in any range. This step by step tutorial will assist all levels of Excel users in getting a random...

We can use the excel sign function to return the sign of a number. The sign function returns: Number zero as 0 A positive number as 1 A negative number as -1 The steps below will walk through the process. Figure 1: How to Use the Excel Sign Function Syntax...