This category is dedicated to covering all the functions and formulas of Excel.
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
Rounding of numbers in Excel is one of the very common things that an excel user performs while working with numbers in excel. In excel, …
“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 😎
“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.
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.
Just like the RAND function in excel, the RANDBETWEEN function is also an in-built excel formula that is useful to create random numbers in excel.
In this blog, we would learn how to generate random numbers between two numbers using the excel RANDBETWEEN formula.
So, let us begin 😎
The RAND function in excel is an in-built mathematical excel formula useful for generating numbers randomly in excel.
In this tutorial, we would learn how to use the RAND formula in excel for generating random numbers in excel.
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
The Excel PRODUCT Function is an inbuilt mathematical formula in excel that is used to find the product of numbers. It is a useful function for quickly multiplying the numbers in excel.
In this tutorial, we would every aspect of the excel PRODUCT formula, including its syntax, arguments, examples, and some important facts.
So, without taking much time, here we go 😎
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 😎
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.
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’.
“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.