Test js math function by  markz  markz 
  Log In  |  Create a FREE Account  |  Everyone's Spreadsheets  |  Tags  |  Help  
 Saving... 
  login to save   undo redo  |  bold italic font text underline more font formatting  |  align left align center align right  |  text color background text color  |  sum hide/show tools
  fx
2
3
"=Math.pow( A1, A2)
Note: Remove the " in cells A3 & B8 to see the functions work, put them back to save a copy with your modifications.
Annuity Calculation
PrincipalMonthly WithdrawelAnnual InterestMonthly InterestNumber of Months
90000
$90,000.00
"= (A8 * Math.pow(1 + D8,E8-1) * D8) / ( Math.pow(1 + D8,E8) - 1 ).025
2.5%
0.0020833333333333333
0.20833333333333334%
75
Note: Formatting Cel B8 as currency seems to break the ability to save a text string in it
"= (A8 * Math.pow(1 + D8,E8-1) * D8) / ( Math.pow(1 + D8,E8) - 1 )"
 
Average Rating:  Not rated (Not yet rated)
 
Name:  Test js math function by  markz markz 
Description:  (no description yet)
Tags:  power exponent annuity interest  

Comments:

markz
markz
Ugly Workaround
Since numsum won't save a formula containing a JavaScript function, they have to be stored as strings, and edited manually every time the spreadsheet is loaded. Feh!
1372 days ago 


Add Comment
[ default color ]
 
 recent: