ZCubes/Spreadsheet functions comparison PMT and looping
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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)
© Copyright 1996-2021, ZCubes, Inc.