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 READ MORE

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, READ MORE

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 READ MORE

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 READ MORE

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. READ MORE

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 READ MORE

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 READ MORE