EXCEL繪製投資效率前緣

黃培暟LEFT,MID,RIGHT,LEN,IF

6月 20, 2024

上課的說明儲存格B1 儲存格C1後面D1,E1拷貝 =FIND(",",$A1) =FIND(",",$A1,B1+1) 儲存格F1 =LEFT($A1,B1-1)然後往下填滿儲存格G1 =MID($A1,B1+1,C1-B1-1)然後往下填滿, 再往右填到H1, I1 儲存格J1 =RIGHT($A1,LEN($A1)-E1) 儲存格K2 =IF(RIGHT(J2,1)= "T",LEFT(J2,LEN(J2)-1)*10^12, LEFT(J2,LEN(J2)-1)*10^9) 說明T是10的12次，否則是B是10的9次儲存格內容代號,英文公司名稱,中文公司名稱,股價,市值 3 10 17 20 代號英文公司名稱中文公司名稱股價市值 NVDA,NVIDIA Corporation,輝達,135.58,3.335T 5 24 27 34 NVDA NVIDIA Corporation 輝達 135.58 3.335T 3.335E+12 MSFT,Microsoft Corporation,微軟,446.34,3.317T 5 27 30 37 MSFT Microsoft Corporation 微軟 446.34 3.317T 3.317E+12 AAPL,Apple Inc.,蘋果,214.29,3.286T 5 16 19 26 AAPL Apple Inc. 蘋果 214.29 3.286T 3.286E+12 GOOG,Alphabet Inc.,谷歌,176.45,2.171T 5 19 22 29 GOOG Alphabet Inc. 谷歌 176.45 2.171T 2.171E+12 AMZN,Amazon.com,亞馬遜,182.81,1.902T 5 16 20 27 AMZN Amazon.com 亞馬遜 182.81 1.902T 1.902E+12 META,Meta Platforms,臉書,499.49,1.267T 5 20 23 30 META Meta Platforms 臉書 499.49 1.267T 1.267E+12 TSM,Taiwan Semiconductor Manufacturing Company Limited,...

閱讀完整內容