What is the ISO.CEILING Function? The ISO.CEILING Function is an Excel Math and Trigonometry function. It is one of the fifteen rounding functions of MS Excel. The function returns a number rounded up to the nearest integer or to the nearest multiple of significance. It works regardless of whether the number given is positive or…
What is the COMBINA Function? The COMBINA Function is an Excel Math and Trigonometry function. It will calculate for a given number of items the number of combinations, along with repetitions. The function was introduced in MS Excel in 2013 and hence not available in earlier versions. Formula =COMBINA(number, number_chosen) The COMBINA function uses the…
What is the DSUM Function? The DSUM Function is categorized under Excel Database functions. The function helps to calculate the sum of a specific field/column in a database for selected records based on user-specified criteria. DSUM was introduced in MS Excel 2000. As a financial analyst, if we need to find out the total number…
What is the DOLLARFR Function? The DOLLARFR Function is an Excel Financial function. DOLLARFR helps in converting a dollar value in decimal notation into a dollar value expressed in fractional notation. The function was introduced in MS Excel 2007. DOLLARFR is very useful when dealing with financial reports and stock market quotes. Financial analysts often…
What is the MDURATION Function? The MDURATION Function is categorized under Excel Financial functions. It will calculate the duration of a security using the Modified Macauley method. In financial analysis, we often evaluate a bond and develop a strategy that will match the duration of assets and liabilities. This is done to minimize the impact…
What is the BASE Function? The BASE Function is available under Excel Mathematical and Trigonometric functions. The function returns a text representation of the calculated value and will convert a number into the supplied base (radix). BASE was introduced in Excel 2013 and is unavailable in earlier versions. Formula =BASE(number, radix, [min_length]) The BASE function…
What is the ISPMT Function? The ISPMT Function is categorized under Excel Financial functions. The function will calculate the interest paid during a specific period of Investment. ISPMT is useful to a financial analyst as it helps predict interest payments while preparing revenue forecasts, annual budgets, etc. For example, suppose a business takes out a…
What is the MOD Function? The MOD Function is categorized under Excel Math and Trigonometry functions. The function helps find a remainder after a number (dividend) is divided by another number (divisor). As a financial analyst, the function is useful when we need to process every nth value. For example, if our data comprises several…
What is the NA Function? The NA Function is categorized under Excel Information functions. It will return the #N/A error value. N/A means “no value available” or “not available.” As a financial analyst, the NA function can be used to mark empty cells and thus avoid the inclusion of empty cells in the calculation. It…
What is the MROUND Function? The MROUND Function is categorized under Excel Math and Trigonometry functions. The function will return a number rounded to a multiple given by the user. MROUND will always round up away from zero. As a financial analyst, the MROUND function helps round a number and eliminate the least significant digits,…
