Round a number to the decimal places I want - Microsoft Support
Round a number to the decimal places you want by using formatting and how to use the ROUND function in a formula to round to the nearest major unit such as thousands, hundreds, tens, or …
Filter by using advanced criteria - Microsoft Support
To indicate an equality comparison operator for either text or a value, type the criteria as a string expression in the appropriate cell in the criteria range: =''= entry '' Where entry is the text or …
Insert subtotals in a list of data in a worksheet - Microsoft Support
You can automatically calculate subtotals and grand totals in a list for a column by using the Subtotal command. Important: Subtotals are not supported in Excel tables. The Subtotal …
Apply data validation to cells - Microsoft Support
Use data validation to restrict the type of data or the values that users enter into a cell, like a dropdown list. Select the cell (s) you want to create a rule for. Select Data >Data Validation. …
Use Goal Seek to find the result you want by adjusting an input …
Next, add the formula for which you have a goal. For the example, use the PMT function: In cell B4, type =PMT(B3/12,B2,B1).This formula calculates the payment amount.
Format numbers as percentages - Microsoft Support
In this example, you want to find 8.9% of 800. If B2 is the price and C2 is the sales tax, you can type the formula =B2*C2 in D2, as shown here: This formula multiplies 800 by 0.089 (the …
Automate tasks with the Macro Recorder - Microsoft Support
To automate a repetitive task, you can record a macro with the Macro Recorder in Microsoft Excel. Imagine you have dates in random formats and you want to apply a single format to all …
Automatically number rows - Microsoft Support
Unlike other Microsoft 365 programs, Excel does not provide a button to number data automatically. However, you can easily add sequential numbers to rows of data by dragging …
Using IF with AND, OR, and NOT functions in Excel
In Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False.
Using structured references with Excel tables - Microsoft Support
To include structured references in your formula, click the table cells you want to reference instead of typing their cell reference in the formula. Let’s use the following example data to …
Use Excel as your calculator - Microsoft Support
Instead of using a calculator, use Microsoft Excel to do the math! You can enter simple formulas to add, divide, multiply, and subtract two or more numeric values. Or use the AutoSum feature …