ZCubes/Spreadsheet functions comparison PMT and looping

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


Spreadsheet functions comparison PMT and looping















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.