SEQUENCE Function in Excel – Generate Number Series

To create or make a list of sequential numbers in excel, Microsoft has come up with a new formula in its Excel 365 version – The SEQUENCE Excel function.

In this tutorial, we would learn how to create and generate a series of simple numbers in excel using the SEQUENCE formula. We would also learn to create a list of roman numbers using the combination of the SEQUENCE and ROMAN excel function.

Here we go 😎

Read moreSEQUENCE Function in Excel – Generate Number Series

ROUNDUP Function in Excel – Rounding Upwards

How to round a number up or upwards up to a specific number of digits or integers in Excel“. This is a very common question that is asked by most of the users working with numbers and decimals in excel. The answer to this is – ‘Using rounding function in excel‘. There are a lot many formulas to round numbers in excel MROUND, ROUNDUP, ROUNDDOWN, ROUND, FLOOR, CEILING, etc. Each of these functions has its own functionalities.

In this tutorial, we would learn how to use the ROUNDUP excel function to round the numbers upwards in excel.

Here we go 😎

Read moreROUNDUP Function in Excel – Rounding Upwards

Excel ROUNDDOWN Function – Rounding Down

How to round a number down or downwards to a specific number of digits in Excel” – This is one of the very common questions that a user faces while working with numbers in excel. There are many formulas to round numbers in excel, each having its own functionalities. To name a few – MROUND, ROUNDUP, ROUNDDOWN, ROUND, FLOOR, CEILING, etc. In this tutorial, we would learn how to use the ROUNDDOWN function to round the numbers downwards in excel.

Read moreExcel ROUNDDOWN Function – Rounding Down

RANDARRAY Function in Excel

In our previous blogs, we had seen how to use the RAND and RANDBETWEEN function in excel to generate random numbers in a cell or range of cells. In this tutorial, we would learn another excel formula to generate random numbers viz. excel RANDARRAY function.

The excel RANDARRAY formula is an advanced version of the RAND and RANDBETWEEN excel functions. This function is currently only available for Microsoft excel Office 365 users. Therefore, RANDARRAY is not available in prior versions of Excel – Excel 2010, Excel 2016, and Excel 2019.

In this tutorial, we would learn how to use the RANDARRAY excel function along with examples.

Read moreRANDARRAY Function in Excel

QUOTIENT Function in Excel – Find Quotient by Division

In one of our previous blogs, we had learned how to use the MOD excel function to find the remainder by dividing one number with another number in excel. In this tutorial, we would learn how to divide a number in excel for finding a quotient after division by using a function.

Similar to the MOD formula, the QUOTIENT formula is also an excel mathematical division formula.

Let us learn different aspects of the excel QUOTIENT formula, including its purpose, syntax, arguments, and example.

Here we go 😎

Read moreQUOTIENT Function in Excel – Find Quotient by Division

POWER Function in Excel – Find Raised to Power

A very common question asked by excel users who play with numbers in excel is – “How to perform raised to the power operation in excel?”. There are two answers to this. The first method is by using the caret (^) symbol on your keyboard and the alternative way is by using an excel formula – the POWER function in excel.

In this tutorial, we would learn how to use the Excel POWER function to do raise to operation in excel along with examples.

Here we go 😎

Read morePOWER Function in Excel – Find Raised to Power

ODD and EVEN Function in Excel

In this tutorial, we would learn two of the math/trig formulas in excel – Excel ODD function and Excel EVEN function.

Similar to the other rounding excel functions, the ODD and EVEN formula in excel allows you for rounding the numbers to the nearest odd or even numbers.

When to Use Excel ODD and EVEN Function

The ODD excel formula is used to round the number to the nearest odd integer which is away from zero. On the other hand, the EVEN excel formula rounds a number to the nearest even integer which is away from zero.

As a result, both these functions results a ‘number’.

Read moreODD and EVEN Function in Excel

MROUND Function in Excel – Rounding in Excel

How to round a number to the nearest decimal place up to 5/10/100/1000 etc.” is one of the important common questions asked by excel users in one or the other forums. To answer this, there is no one formula to round numbers in excel. Excel provides many rounding functions in its formula library for rounding numbers in excel. To name to few – MROUND, ROUNDUP, ROUNDDOWN, ROUND, FLOOR, CEILING, etc. Each of these functions has its own functionalities. In this tutorial, we would learn the excel MROUND rounding function.

Read moreMROUND Function in Excel – Rounding in Excel