XL: ?????? ?????? ?? ??? ???? ???? ???? Paid

???? ?????? ???? ??????
???? ID: 71952 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
??? ?? ??????? ???? | ??? ?? ??????? ????

?? ????? ??

??????

?? ??????? ??? ?? ??? ?????? ???? ?? ??? ???? ?? ?? paid ????? ????? ??? ???? ?? ??? ?? CUMIPMT ?????????? ?????? ?? ????? ?? ?????

?? ???? ??? ??????? ?? ????? ?????? ?? ?????? ???????? ?? ?? ????? ????? ?? ?? ???? ?? ?? ?? ??? ????? ?????? ??? ???? ?? ??? IPMT ?????????? ?????? ?? ????? ?? ???? ???? ??? ????? ?? ???? ???? ?? ??? ??? (?????? ???????) ?? ?? ?????? ?? paid IPMT ?????? ????? ???? ?? ???? ??? ???? ????? ??? ?? ??? ??? "???? ???????" ??? ??? ????? ???? ??? ???

???? ???????

?????? 1: CUMIPMT ?????????? ??????

??? ????? ?? ??? ???? ??????? ???? ?? ??? paid ?? ??? ????? ?? ??? CUMIPMT ?????????? ?????? ?? ????? ????, ????? ?????? ??? ??? ????? ?? ???? ?????

?? ?????? ????? ?? ?? ???? 12 ?????? ?? ?? ?? 9 ??????? ?? ?? ??????? ????? ?? ?? ??? ?? ??? calculate ????? ????? ????? ???, ?? ?? ????? 360 ?????? ?? ????? ??, ?? ?? ?? ??????? ??? $ 125,000 ??????? ?? ????? ???
  1. Excel ??????? ???? ?? ??? ?? ????????????? ??????
  2. ????? ???? ????? ?? ???????? ????:

    ?????? ??????? ????? ???? 12 ?????? ?? ??????? per annum.0075 ???? ???
  3. ?????????? ??? ????? ????? ???? ????:
    =CUMIPMT(0.0075,360,125000,1,12,0)
    ???:: ??? CUMIPMT ?????????? ?????? ?????? ???? ??, ?? ?? ???????? Toolpak ??-?? ??????? ???? ?????

  4. ????? ??-11215.34 ???? ?? (-$ 11,215.34)?

?????? 2: IPMT ?????????? ??????

???? ???? ?? ???? ???? ?? ??? IPMT ?????????? ?????? ?? ????? ????, ????? ????? ?? ???? ????:
  1. Excel ??????? ???? ?? ??? ?? ????????????? ??????
  2. ?????????? ??? ????? ????? ???? ????:
    =SUM(IPMT(.0075,ROW(A1:A12),360,-125000))
  3. ????? ?? ???? ???? ?? ??? ??? ???? ???? ?? ??? CTRL + SHIFT + ENTER ??????
  4. ????? 11215.34 ($ 11,215.34) ???? ???
ROW ?????? ????? ?? ?? ????? ??? period ???????? ?? ???? ??? ???? ?? ???, ?? ???? ?????? ?? ???? ????? ???? ?? ????? ?? ?????? ???, ROW(A1:A12) ???? {1 2; 3; 4; 5; 6; 7; 8; 9; 10; 11; 12}?

??????? ?? ???? ?????? ?? ??? ?? ???? ??? ???? ??? ?????? ?? ???, ??????? ???? ?? ??? paid ????? ?? ????, ?? ??? ????? ??????A13:A24A1:A12 ROW ?????? ?? ????? ???

??????

IPMT ?????????? ?????? ?? ???? ??? ???? ??????? ?? ??? ????? ????Microsoft Excel ???????? ???????????, ??????ipmtOffice ????? ?? ????? ????????, ?? ???? ?????????? ?? ??????

CUMIPMT ?????????? ?????? ?? ???? ??? ???? ??????? ?? ??? ????? ????Microsoft Excel ???????? ???????????, ??????cumipmtOffice ????? ?? ????? ????????, ?? ???? ?????????? ?? ??????

?????? ?????????? ?????? ?? ???? ??? ???? ??????? ?? ??? ????? ????Microsoft Excel ???????? ???????????, ???????????? ?????????? ??????Office ????? ?? ????? ????????, ?? ???? ?????????? ?? ??????

???? ??????? ???? ??????? ?? ???????? toolpak ?? ?????, ?? ??? ????? ????Microsoft Excel ???????? ???????????, ??????atpOffice ????? ?? ????? ????????, ?? ???? ?????????? ?? ??????

???

???? ID: 71952 - ????? ???????: 20 ??????? 2011 - ??????: 5.0
???? ???? ???? ??:
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 95 Standard Edition
  • Microsoft Excel 98 for Macintosh
??????: 
kbhowto kbinfo kbmt KB71952 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:71952

??????????? ???

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com