 |
Excel Magic Trick #113: Nested IF & Short Term Loans Posted by: ExcelIsFun
Video duration: 622 seconds Global video hits: 231 Nested IF example. See how to use the TEXT function, concatenation using the Ampersand (&) symbol and the IF function to create labels and loan calculating formulas for various short-term loans. Related: college, community, excel, finance, formula, function, functions, gel, girvin, highline, if, mike, nested, text |
 |
Excel Magic Trick #88: EDATE function Invoicing & Loans Posted by: ExcelIsFun
Video duration: 117 seconds Global video hits: 597 See how to use the EDATE function to calculate a date an indicated number of months before or after a specified date. See how to calculate maturity dates or due dates that fall on the same day of the month as the date of issue. Related: as, college, community, date, dates, day, edate, excel, fall, function, gel, girvin, highline, issue, mike, month, of, on, same, that |