All resources related to MATH for Excel and Google Sheets.

All articles
MATH

Excel SUBTOTAL Function

The Excel SUBTOTAL function is used to find out an aggregate for some given values. SUBTOTAL function can be used to return different results in the form of SUM, COUNT, MAX, AVERAGE, and other results. In short, SUBTOTAL function is used to get a subtotal from a list of values....

Excel RADIANS Function

The RADIANS function in Excel is used to convert angles measured in degrees into radians. This function is a Math Function and is a worksheet function, which means that it can be entered in a cell as the part of a formula. Figure 1: Excel RADIANS Function The syntax of...

How to use the Excel ODD function

We use the Excel ODD function, which is a built-in function to round up a given number and return the next odd integer. With this function, we round up numbers such that positive numbers become larger and negative numbers become smaller. This article will walk through the process. Figure 1...

Excel MROUND Function

We use the MROUND function to round off a given set of numbers either up or down to the nearest specified multiple. The steps below will walk through the process. Figure 1- Result of rounding off numbers using the MROUND function General formula =MROUND(num,multiple) Formula =MROUND (B5,C5) Setting up the...

Excel FLOOR Function

We can use Excel FLOOR function to round numbers down to the nearest specified multiple. To learn how to use this function, read this post as it provides a step-by-step guide on how to round down numbers using the FLOOR function. Figure 1: Use of Excel FLOOR function Syntax of...

Excel POWER Function

Figure 1. of Excel POWER Function. In the event that we want to determine a very small level of tolerance for vast distances. At some point we will have to raise a number to a specific power. We are going to utilize the Excel POWER Function. This article will walk...

Excel MOD Function

We can use the Excel MOD function if we want to get the remainder of two numbers after division. While this might seem challenging, this step-by-step guide will enable you use the MOD function to get the remainder of any two numbers after division. Figure 1: Using the MOD function...

Excel DECIMAL Function

Numbers can be represented in a base from 2 to 36. While working with Excel, we are able to convert a number from any base to a base of 10. This step by step tutorial will assist all levels of Excel users in converting a number to its decimal value...

Excel ARABIC Function

While working with Excel, we are able to convert a Roman numeral into its Arabic numeral form by using the ARABIC function. This step by step tutorial will assist all levels of Excel users in the syntax and usage of ARABIC function. Figure 1. Final result: Excel ARABIC function...

Excel ROMAN Function

Figure 1. of ROMAN Function in Excel. In this post, we are going to describe the formula syntax of the ROMAN Function in Excel and demonstrate its purpose. Generic Formula ROMAN(number, [form]) The ROMAN Function will automatically convert Number Values into Roman numerals. How to use the Excel ROMAN Function...