How to use Excel ROUND function

Introduction Round function in excel is a Math/Trig function. It is a worksheet function. It is used in rounding of a number to a defined number of digits. For example, if cell B1 contains value 2.478 and it needs to be rounded off to one decimal place, one can used ROUND function to return value 2.5 Syntax =ROUND(Number, Num_Digits) Arguments Number- The number or cell containing the number that is to be rounded off.Num_Digits- The number of digits to which…

Continue Reading

How to use Excel FLOOR.PRECISE function

Introduction FLOOR.PRECISE function in excel is a Math/Trig function. It is a worksheet function. It rounds down the given function to a defined multiple or the nearest integer. It is different from FLOOR function in the sense that whatever may be the sign of the number, it always rounds down. By default it uses 1 as a multiple. For example, number 2.5 is rounded down to nearest multiple of 1 by formula =FLOOR.PRECISE(2.5,1) which gives 2 as the result. Syntax…

Continue Reading

How to use Excel FLOOR function

Introduction FLOOR function in excel is a Math/Trig function. It is a worksheet function. It rounds down the given number to the nearest multiple , towards zero. For example, number 1.5 is rounded down by significance 1 to the nearest integer towards zero by formula =FLOOR(1.5,1) which gives 1 as the result. FLOOR function is same as MROUND function except it always rounds down.   Syntax =FLOOR(Number, Significance) Arguments Number- The number or cell containing the number that is to be…

Continue Reading

How to use Excel EVEN function

Introduction EVEN in excel is a Math/Trig function. It is a worksheet function. It rounds up the given function to the nearest even integer. For example, number 1.5 is rounded up to the nearest even integer by using the formula =EVEN(1.5) which gives 2 as the result. It can also be used to find the number of items which come in bundles of two’s.  Syntax =EVEN(Number) Arguments Number- The number or cell containing the number that is to be rounded…

Continue Reading

Subtotal Formula in Microsoft Excel

Excel version in which SUBTOTAL function can work: Excel SUBTOTAL formula can work in all of your latest version of Microsoft office. About SUBTOTAL function in excel: Subtotal Formula helps to find out subtotal of the numbers in a column from the database. It is a built in function in Excel, that can be categorize as Math or Trig function. It can be used also as a worksheet  function. This function can be clubbed with other formula also. Syntax for…

Continue Reading

SUMIFS Functions in Excel

SUMIF function is used to add the cells in a range which meets the given criteria. In SUMIF function you can give only one criteria. SUMIFS function adds the cells in a range which meets multiple criteria. Syntax for SUMIFS function is=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)The sequence of arguments are different in SUMIFS function as compare to SUMIF.sum_range argument is the first argument in the SUMIFS function. This is the range of cells the value of which is to…

Continue Reading

How to use Excel SUMIF Formula

In this article we have explained how to use Excel SUMIF Formula.Excel SUMIF function can be used to sum the value in a range that meets the given criteria.  Syntax for Excel SUMIF Formula is: =SUMIF(range, criteria,[sum_range])range is the argument that specifies the cells in which the criteria or the condition is to be checked. We should select the range of cells in the formula.criteria is the condition to be checked, which can be text, number, cell reference, formula etc. The criteria…

Continue Reading
Close Menu