How to correct a #NAME? error - Microsoft Support
The top reason why the #NAME? error appears in the formula is because there's a typo in the formula name. Look at the following example: Important: The #NAME? error signifies that something needs to be corrected in the syntax, so when you see the error in your formula, resolve it.
Create a multiplication table - Microsoft Support
Let's say you want to help a child to better understand math concepts by creating a multiplication table. Enter numbers 1-10 in cells A2 to A11 and again in cells B1 to K1. Enter this formula in cell B2. The $ locks the value for the header row and the formula multiplies it …
IFERROR function - Microsoft Support
You can use the IFERROR function to trap and handle errors in a formula. IFERROR returns a value you specify if a formula evaluates to an error; otherwise, it returns the result of the formula.
Import data from the web - Microsoft Support
In the Search for online templates box, search for Power Query. Open the Power Query tutorial and press Create. On the Import Data from Web worksheet, copy the URL, which is a Wikipedia page for the FIFA World Cup standings. Select Data > Get & Transform > From Web.
COUNT function - Microsoft Support
Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers. For example, you can enter the following formula to count the numbers in the range A1:A20: =COUNT (A1:A20).
Import from an Excel Table - Microsoft Support
Position the cursor on the Excel table, Select Data > Get & Transform Data > From Table/Range. Excel opens the Power Query Editor with your data displayed in a preview pane. To display all query tables in the workbook from the Queries pane, …
Using IF to check if a cell is blank - Microsoft Support
Here is an example of a very common method of using "" to prevent a formula from calculating if a dependent cell is blank: =IF (D3="","",YourFormula ()) IF (D3 is nothing, then return nothing, otherwise calculate your formula).
IF function - Microsoft Support
The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False.
Use Excel as your calculator - Microsoft Support
Use Excel as your calculator. 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 to quickly total a series of values without entering them manually in a formula. After you create a formula, you can copy it ...
ROUND function - Microsoft Support
The ROUND function rounds a number to a specified number of digits. For example, if cell A1 contains 23.7825, and you want to round that value to two decimal places, you can use the following formula: =ROUND (A1, 2) The result of this function is 23.78.
EOMONTH function - Microsoft Support
Returns the serial number for the last day of the month that is the indicated number of months before or after start_date. Use EOMONTH to calculate maturity dates or due dates that fall on the last day of the month.