Finance Unit | search
Click here to view Finance Unit news from 60+ newspapers.
Bookmark or Share- Look up values with VLOOKUP, INDEX, or MATCH - Microsoft SupportHere's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work. For VLOOKUP, this first argument is the value that you want to find. This argument can be a cell reference, or a fixed value such as "smith" or 21,000.
- RATE function - Microsoft SupportThis article describes the formula syntax and usage of the RATE function in Microsoft Excel. Returns the interest rate per period of an annuity. RATE is calculated by iteration and can have zero or more solutions. If the successive results of RATE do not converge to within 0.0000001 after 20 iterations, RATE returns the #NUM! error value.
- Format text or numbers as superscript or subscriptThere are several ways to apply superscript and subscript to text or numbers in your worksheet. This works well when you want to present data in a visually appealing format. To format numeric values or formulas for a mathematical, chemical, or other type of technical expression, use the equation symbols and templates.
- PRICE function - Microsoft SupportThis article describes the formula syntax and usage of the PRICE function in Microsoft Excel. Returns the price per $100 face value of a security that pays periodic interest. PRICE (settlement, maturity, rate, yld, redemption, frequency, [basis])
- Get a currency exchange rate - Microsoft SupportWith the Currencies data type you can easily get and compare exchange rates from around the world. In this article, you'll learn how to enter currency pairs, convert them into a data type, and extract more information for robust data. Note: Currency pairs are only available to Microsoft 365 accounts (Worldwide Multi-Tenant clients.)
More
