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...") |
|||
| (One intermediate revision by one other user not shown) | |||
| 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) | ||
| + | |||
| + | </br> | ||
| + | *[[ZCubes/Computations_with_Units_and_Range_of_Values | Computations with Units ]] | ||
| + | *[[Z3 | Z3 home]] | ||
| + | *[[Z^3 Language Documentation]] | ||
| + | *[[Main_Page | About ZCubes ]] | ||
| + | *[[ZCubes_Videos | ZCubes Videos and Tutorials]] | ||
<br/> | <br/> | ||
| − | © Copyright 1996- | + | |
| + | © Copyright 1996-2021, ZCubes, Inc. | ||
Latest revision as of 06:48, 9 March 2021
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.