INT function is used to round down the numeric value to nearest integer. INT Function has one required argument i.e. number.
=INT(number)
Here, we have sample database and want to round down the sales movement ( % ) for various region.
We will be using INT function as follows:
Excel INT function is very simple and easy to use. This example will help you explore the use of the INT function in Excel.
Hope you learnt this Function,
Don’t forget to leave your valuable comments!
https://youtu.be/HmJL_y93pAs WEEKNUM function helps to calculate the week number of the given date in a year. It considers 1st January as first week by default and through the output for the given input date. Syntax:…
COUNTBLANK function is used to get the total count of Blank or Empty cell in range.
COUNTBLANK Function has one required argument i.e. range.
SUMPRODUCT function performs multiplication of numbers within arrays and then sum the values SUMPRODUCT function has array1, 2.. arguments.
INDIRECT function is used to convert the text/string into cell reference. Function provides output as the value of that cell reference.
Watch: How to use SUMIF & SUMIFS Function in Excel? What is SUMIF Function? The SUMIF function in Excel adds up values in a range of cells that meet certain criteria. Click here to Read Full…
Microsoft Excel “DAY, MONTH, YEAR Functions” are date related functions helps to extract the Day, Month or Year from a Date.