Math and trigonometry

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 …

How to use Excel ROUND function 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 …

How to use Excel FLOOR function 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 …

How to use Excel EVEN 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 Functions in Excel 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 …

How to use Excel SUMIF Formula Read More »