Excel AVERAGEIFS function AVERAGEIFS function in Excel finds average of values based on multiple criteria. It was introduced in Excel 2007 and can be used on all modern versions Excel 2016, Excel 2013, Excel 2010 and Excel 2007. Formula =AVERAGEIFS(average_range, range1, criteria1, [range2, criteria2], …) Here, average_range is the …
Continue reading AVERAGEIFS function in excelExcel Functions
Excel SUMIFS function SUMIFS function in Excel finds conditional sum of values based on multiple criteria. It was introduced in Excel 2007 and can be used on all modern versions Excel 2016, Excel 2013, Excel 2010 and Excel 2007. SUMIFS basically adds up all of its arguments that meet multiple criteria. Formula …
Continue reading SUMIFS function in ExcelCEILING function Excel Excel CEILING function returns number rounded up, away from zero, to the nearest multiple of significance. Formula =CEILING(number, significance) Here, number is value you want to round. significance provides the multiple value to which you want to round. Rules : Regardless of the sign of number, a value is rounded …
Continue reading Excel CEILING functionFLOOR function Excel FLOOR function rounds number down, toward zero, to the nearest multiple provided. Formula =FLOOR(number, multiple) Here, number is value you want to round. multiple provides the multiple value to which you want to round. Rules : If the sign of number is positive, a value is rounded …
Continue reading Excel FLOOR functionExcel TRUNC function TRUNC function truncates a number by removing the fractional part of the number. Function =TRUNC(number, [num_digits]) Here, number is the value to be truncated. This is mandatory field. Num_digits is a number specifying the precision of the truncation. The default value for num_digits is 0 (zero). Example 1 : …
Continue reading Truncate number using Excel TRUNC function