Tuesday, 13 December 2016

CALCULATE ANNUITY USING EXCEL

i. Click the function button (fx), select Financial and double-click PMT.
Figure 7 shows the dialogue box

 ii. A dialog box appears and asks what data to use.

Figure 8 shows the formula box

iii. After fill the box with the data, the answer will show up.
Figure 9 shows the data filled in the box and the result of the formula
Posted by at

6 comments:

  1. Unknown13 December 2016 at 05:24

    This can make our work more easier at the same time we also can get the correct answer

    ReplyDelete
  2. Shudud13 December 2016 at 07:52

    Muchas gracias

    ReplyDelete
  3. narishransc.blogspot.com14 December 2016 at 02:57

    This comment has been removed by the author.

    ReplyDelete
  4. erin15 December 2016 at 00:29

    a very good explanation how to use formula using Microsoft Excel. Good job!

    ReplyDelete

Subscribe to: Post Comments (Atom)