View source for ZCubes/Spreadsheet functions comparison PMT and looping

==Spreadsheet functions comparison PMT and looping==
<br/>
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==
<br/>
{{#ev:youtube|lnDGpYfkP9s|480|left|Spreadsheet functions comparison PMT and looping}}
<br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/>


==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/>

&copy; Copyright 1996-2021, ZCubes, Inc.