Click HERE to have updates like this one sent directly to your inbox.
One of the challenges you will encounter building monthly
debt schedules is the need to calculate and show interest expense in each
month, and then reflect the payment of interest at the end of the quarter. This
video provides a helpful approach.
Click on the icon in the lower right-hand corner of the video player to expand to full screen.
1. How to use =MOD() in an =IF() statement to calculate quarterly interest payments.2. Multiple uses of the =OR() function.
1. Why =SUM() has limitations.2. How the =OFFSET() function can be used to return arrays.3. How to effectively use =SUM and =OFFSET together.4. How to use F9 to audit formulas.
A) really boring
B) pretty sweet
C) super important
D) somewhat easy
E) kind of hard
G) all of the above
*Answers a, b, c, d, e, f and g are all correct.
should be simple.*