you might catch this error with theIFERROR functionand display a custom result if you like. INDIRECT is useful when you want to assemble a text value that can be used as a valid reference.

Explanation The INDIRECT function tries to evaluate text as a worksheet reference. INDIRECT is useful when you want to assemble a text value that can be used as a valid reference.

Explanation TheSUMPRODUCT functionmultiplies ranges or arrays together and returns the sum of products. This sounds boring, but SUMPRODUCT is an elegant and versatile function, which this example illustrates nicely. In this example, SUMPRODUCT is configured with twoarrays. Effectively, the second array acts as a filter for the values in the first array.

EDATE returns aserial number corresponding to a date. To display the result as a date, apply anumber format of your choice. The EDATE function takes twoarguments,start_dateandmonths: Note: The EDATE function returns thesameday of the month. If you want to get thelastday of a month, use theEOMONTH function. We can do this with the following formulas: The first formula does not change the date sincemonthsis zero. In all cases, EDATE returns the 1st of the month since the start date is also the 1st....

If you want the cursor to move to theformula bar, see below. “Point” and “Enter” work similarly and allow you to point to a cell. “Edit” mode simply moves the cursor in the formula text. Want to edit directly in the formula bar?

Nominal interest rate is the stated rate on the financial product. Effective annual interest rate is the interest rate actually earned due to compounding. The effective rate is the actual rate due to compounding. The nominal rate is typically the stated rate.

Explanation The Effective Annual Rate (EAR) is the interest rate after factoring in compounding. The EFFECT function returns the calculated EAR for each of the given periods. This formula is used to check the results from EFFECT. Effective annual interest rate is the interest rate actually earned due to compounding. RRI Function The Excel RRI function returns an equivalent interest rate for the growth of an investment. it’s possible for you to use RRI to calculate Compound Annual Growth Rate (CAGR) in Excel....

When working with Excel formulas, a common term is “empty string”. A text string is atext valuelike “apple”. An empty string is a text value that has no value. If the value is greater than 10, the formula returns “x” as text. Otherwise, IF returns an empty string (""). When an empty string is the result of a formula, it looks like the cell is blank. So, empty strings are commonly used to return a value that looks like nothing....

Some characters cannot be part of a URL and are “reserved”. Only characters that are reserved are encoded by ENCODEURL; other characters are left untouched. Example To use ENCODEURL, supply text or a cell reference that contains text. In the example below, ENCODEURL is used to encode the text “Hello World!” Reserved characters The table below shows a list of reserved characters and their url-encoded equivalent. Related functions WEBSERVICE Function The Excel WEBSERVICE function returns data from a web service....

Related videos The videos below demonstrate this shortcut.

About This Shortcut This shortcut is an alternative to pressing enter/return when entering data. It’s useful when the next value you want to enter is to the left. Related videos The videos below demonstrate this shortcut. Excel Table Options Shortcuts to enter data

About This Shortcut This shortcut is an alternative to pressing enter/return when entering data. It’s useful when the next value you want to enter is to the right. Related videos The videos below demonstrate this shortcut.

About This Shortcut This shortcut is an alternative to pressing enter/return when entering data. It’s useful when the next value you want to enter is above. Related videos The videos below demonstrate this shortcut.