發表文章

目前顯示的是 5月, 2026的文章

計算機

JavaScript 簡易計算機 C / * - 7 8 9 + 4 5 6 = 1 2 3 0 .

吳祐安w3shools的EXCEL函數

圖片
https://www.w3schools.com/excel/excel_functions.php Function Description =AND Returns TRUE or FALSE based on two or more conditions =AVERAGE Calculates the average (arithmetic mean) =AVERAGEIF Calculates the average of a range based on a TRUE or FALSE condition =AVERAGEIFS Calculates the average of a range based on one or more TRUE/FALSE conditions =CONCAT Links together the content of multiple cells =COUNT Counts cells with numbers in a range =COUNTA Counts all cells in a range that has values, both numbers and letters =COUNTBLANK Counts blank cells in a range =COUNTIF Counts cells as specified =COUNTIFS Counts cells in a range based on one or more TRUE or FALSE condition =IF Returns values based on a TRUE or FALSE condition =IFS Returns values based on one or more TRUE or FALSE conditions =LEFT Returns values from the left side of a cell =LOWER Reformats content to lowercase =MAX Returns the highest value in a range =MEDIAN Returns the middle value in the data =MIN Returns the lowe...

吳祐安Javascript財務內部報酬率計算四期現金流量圖形介

大部份的程式語言,指令之間用;分隔,可是為了閱讀程式碼,會分行而且縮,python乾脆將「分行」有;的功能,相同的縮排代表同一個{區塊} html IRR 財務計算機 四期現金流量 IRR 計算機 第 0 期 (投入): 第 1 期: 第 2 期: 第 3 期: 計算 IRR 並更新圖表 IRR: --