羅婕珉, 選擇性貼上, 轉置Transpose, VLOOKUP, HLOOKUP, Column, Row
EXCEL函數:
- =VLOOKUP($A2,損益表,14,FALSE)
- =VLOOKUP($A13,$A$2:$F$8,F$12,)
- =COLUMN(E1)
- =ROW(A1)
- =TRANSPOSE(F2:F5)
- =HLOOKUP(B$28,橫變直,$A29,FALSE)
第十五週HTML+CSS+JavaScript+WORD轉PDF
利率y(rate) 期數n(nper) 金流m(pmt) 終值f(fv) 參考 劉任昌金融市場講義 羅婕珉學習HTML+CSS+JavaScript程式碼 <style> h1{border: 20px outset red; background-color: green; color: white; text-align: center;} </style> <script> function computePV(){ var r = document.getElementById("rate").value; var n = document.getElementById("nper").value; var m = document.getElementById("pmt").value; var f = document.getElementById("fv").value; pvif =r; pvif++; pvif =1/pvif**n; var pv = (1-pvif)*m/r + f * pvif; document.getElementById("pv").innerHTML = pv; } </script> <body> <table border="1"> <tr><td>利率y(rate)</td><td>期數n(nper)</td><td>金流m(pmt)</td><td>終值f(fv)</td></tr> <td><input id="rate" type="number" /></td> <td><input id="nper" type="number...
留言
張貼留言