The Excel UNICODE function returns a number (code point) corresponding to a Unicode character given as text. The result is a number in decimal notation. For example, the Euro symbol (€) is code point 8364 in decimal notation, so UNICODE returns 8364:
...Read more
The UNICHAR function returns the Unicode character at a given code point, provided as a number in decimal format. To illustrate, the Euro symbol (€) has a code point of 8364 in decimal notation. The following formula will return the Euro character:
...Read more
This chart is an example of a column chart that uses a "floating bar" technique to plot daylight hours on the chart in way that makes the bars look like the are floating above the horizontal axis. The trick in this case is to create three helper columns that do not exist in the original data: daylight, evening, and hrs. The video here walks through this process.
At the core, this formula uses the MID function to extract each character of a text string in reverse order. The starting character is given as a list of numbers in descending order hard-coded as array constant:
MID(B5,{10,9,8,7,6,5,4,3,2,1},1)
...Read moreThe Excel AMORDEGRC function returns the depreciation for each accounting period by using a depreciation coefficient. This function is provided for the French accounting system. Depreciation is prorated based on the date an asset is purchased in the first period. AMORDEGRC...Read more
The Excel AMORLINC function returns the depreciation for a given accounting period. This function is provided for the French accounting system. Depreciation is prorated based on the date an asset is purchased in the first period.
In the example shown, an asset was ...Read more
The RECEIVED function returns the amount received at maturity for a fully invested security. A fully invested security does not pay periodic interest before maturity. The interest income is the difference between the redemption value of the security and the original investment.
The FVSCHEDULE function calculates the future value of a single sum based on a schedule of interest rates. The interest rates can vary in each period. As such, FVSCHEDULE can be used to find the future value of an investment with a variable or adjustable rate.
By contrast, the...Read more
In finance, duration is a measure of the price sensitivity to changes in interest rates for an asset that pays interest on a periodic basis, like a bond. Duration can be used by financial managers as part of a strategy to minimize the impact of interest rates changes on net worth. Modified...Read more