FLOOR function - Microsoft Support
This article describes the formula syntax and usage of the FLOOR function in Microsoft Excel. Rounds number down, toward zero, to the nearest multiple of significance. FLOOR (number, significance) The FLOOR function syntax has the following arguments: Number Required. The numeric value you want to round. Significance Required.
SUBTOTAL function - Microsoft Support
How to use the SUBTOTAL function in Excel to return a subtotal in a list or database.
ROUND function - Microsoft Support
To always round up (away from zero), use the ROUNDUP function. To always round down (toward zero), use the ROUNDDOWN function. To round a number to a specific multiple (for example, to round to the nearest 0.5), use the MROUND function. Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet.
How to correct a #VALUE! error in the VLOOKUP function
Problem: The lookup_value argument is more than 255 characters. Solution: Shorten the value, or use a combination of INDEX and MATCH functions as a workaround. This is an array formula. So either press ENTER (only if you have Microsoft 365) or CTRL+SHIFT+ENTER.
MROUND function - Microsoft Support
MROUND returns a number rounded to the desired multiple. MROUND (number, multiple) The MROUND function syntax has the following arguments: Number Required. The value to round. Multiple Required. The multiple to which you want to round number.
GETPIVOTDATA function - Microsoft Support
You can quickly enter a simple GETPIVOTDATA formula by typing = (the equal sign) in the cell you want to return the value to and then clicking the cell in the PivotTable that contains the data you want to return.
Changes to internal calculations of linear trendlines in a chart
Over several versions, Excel made a series of changes to internal calculations to correct results from chart trendlines where the trendline intercept is set to zero (0). These changes don't actually change the line or appearance, just the calculation of R 2 if …
DAYS function - Microsoft Support
This article describes the formula syntax and usage of the DAYS function in Microsoft Excel. For information about the DAY function, see DAY function. Returns the number of days between two dates. DAYS (end_date, start_date) The DAYS function syntax has the following arguments. End_date Required.
Display numbers in scientific (exponential) notation
To remove the exponential notation from large numbers, you can apply a different number format, such as Number. The Scientific format displays a number in exponential notation, replacing part of the number with E+n, in which E (exponent) multiplies the preceding number by 10 to …
Total the data in an Excel table - Microsoft Support
You can quickly total data in an Excel table by enabling the Total Row option, and then use one of several functions that are provided in a drop-down list for each table column. The Total Row default selections use the SUBTOTAL function, which allow you to include or ignore hidden table rows, however you can also use other functions.
COUNTIF function - Microsoft Support
Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list. In its simplest form, COUNTIF says: =COUNTIF (Where do you want to look?, What do you want to look for?) For example: