Difference between revisions of "ZCubes/Spreadsheet functions comparison PMT and looping"
Jump to navigation
Jump to search
(Created page with "==Spreadsheet functions comparison PMT and looping== <br/> ZCubes handles the spreadsheet functions in a unique and revolutionary way. This video compares certain spreadsheet...") |
|||
| Line 9: | Line 9: | ||
| + | ==Code== | ||
| + | PMT(8%/12,10,10000,0,0) | ||
| + | |||
| + | PMT(8%/12,10,10000,0,1) | ||
| + | |||
| + | PMT(8%/12,10..20,10000,0,1) | ||
| + | |||
| + | PMT(8%/12,10..120,10000,0,1) | ||
| + | |||
| + | PMT(8%/12,10..120,10000,0,0..1) | ||
<<[[Learn_ZCubes | Learn ZCubes ]] | <<[[Learn_ZCubes | Learn ZCubes ]] | ||
<br/> | <br/> | ||
© Copyright 1996-2020, ZCubes, Inc. | © Copyright 1996-2020, ZCubes, Inc. | ||
Revision as of 03:49, 11 May 2020
Spreadsheet functions comparison PMT and looping
ZCubes handles the spreadsheet functions in a unique and revolutionary way. This video compares certain spreadsheet functions in ordinary spreadsheets with ZCubes. It demonstrates how the PMT calculation ( loan payment) can be done in ZCubes for a range of values easily. In ordinary spreadsheets, evaluating the computation for a range of values is difficult, whereas in ZCubes it is easy and natural. You can compute monthly payments required for various lengths of loan in one line of command.
Video
Code
PMT(8%/12,10,10000,0,0)
PMT(8%/12,10,10000,0,1)
PMT(8%/12,10..20,10000,0,1)
PMT(8%/12,10..120,10000,0,1)
PMT(8%/12,10..120,10000,0,0..1)
<< Learn ZCubes
© Copyright 1996-2020, ZCubes, Inc.