=ROUND(number,num_digits)
We can use Round formula in excel. There are different round formulas.
When there is decimals in figures so it create problems in calculation here we need to use round formula to round off figures which makes calculations easy its limited to specified decimals.
Let us understand all these with few examples given below.
Here we are using ROUND Formula to round figures in excel. Round Formula ask for 2 arguments. 1 is number and num digits.
If we want to round in 1 decimal the formula is =ROUND(D3,1).
If we want to round in 2 decimal the formula is =ROUND(D4,2)
If we want to round nearest to whole number formula is =E5=ROUND(D4,2)
If we want to round to nearest 10 the formula is=ROUND(D6,-1)
If we want to round to nearest 100 the formula is =ROUND(D7,-2)
If we want to round to nearest 1000 the formula is =ROUND(D8,-3).
As shown in below image
Now we will learn ROUNDUP excel formula. ROUNDUP always roundoff the number to next number. In ROUND we are rounding the value to below numbers or down number. Rest everything is same.
If we want to round in 1 decimal the formula is ==ROUNDUP(D3,1).
If we want to round in 2 decimal the formula is =ROUNDUP(D4,2)
If we want to round nearest to whole number formula is =ROUNDUP(D5,0)
If we want to round to nearest 10 the formula is=ROUNDUP(D6,-1)
If we want to round to nearest 100 the formula is =ROUND(D7,-2)
If we want to round to nearest 1000 the formula is =ROUND(D8,-3)
As shown in below image
SUMPRODUCT function performs multiplication of numbers within arrays and then sum the values SUMPRODUCT function has array1, 2.. arguments.
In an “IF function” there will be two output i.e. TRUE or FALSE since either the statement will be “TRUE” or “FALSE”. If the statement is matching or correct, then output will be “TRUE” or if the statement is not matching or not correct then the output will be “FALSE
MIN function is used to get the smallest number in range or list of values.MIN function has one required i.e. number1 and optional argument i.e. [number2]
SUM Function in Excel Excel is a mathematical spreadsheet where you can perform multiple calculations with the help of Excel Formulas. These are automated formulas which refreshes automatically once you refresh your data in a…
MAX function is used to get the largest number in range or list of values. MAX function has one required argument i.e. number1
AVERAGEIF function is used to get the “average” of values for matching criteria across range. Average = Sum of all values / number of items.