林乙書EXCEL樞紐分析weeekday
樞紐分析，把股票報酬率分成五組，從-10%到10%，分成五組
IF巣狀條件設定
- 大漲超過6%
- 小漲超過2%
- 平盤2%到-2%
- 小跌超過-2%
- 大跌超過-6%
- =IF(G2>6%,"大漲",IF(G2>2%,"小漲",IF(G2>-2%,"平盤",IF(G2>-6%,"小跌","大跌"))))
林乙書示範EXCEL樞紐分析
老師示範EXCEL樞紐分析
EXCE函數
https://100ifelse.blogspot.com/2021/12/excelweekday.html
回覆刪除https://d11017235.blogspot.com/2021/12/excelweeekday.html
回覆刪除https://liaotingyu.blogspot.com/2021/12/d11017232.html
回覆刪除https://www.blogger.com/blog/post/edit/preview/8003165942710740669/4068378958059092554
回覆刪除https://yinghsien2002.blogspot.com/2021/12/1101227.html
回覆刪除https://sandy920529.blogspot.com/2021/12/excel.html
回覆刪除https://grace0313.blogspot.com/2021/12/excel_26.html
回覆刪除https://d11017240.blogspot.com/2021/12/excelweeekday.html
回覆刪除https://takmingfinanc.blogspot.com/2021/12/excelweek-day.html
回覆刪除https://d11017247.blogspot.com/2021/12/excelweeekday.html
回覆刪除https://d11017242.blogspot.com/2021/12/excelweeekday.html
回覆刪除https://henry-web-0519.blogspot.com/2021/12/excelweek-day.html
回覆刪除d11017210 https://jnklkuhdukrjuh.blogspot.com/2021/12/permanent-link.html
回覆刪除https://d11017201.blogspot.com/2021/12/excelweeekday.html
回覆刪除https://liang-ching.blogspot.com/2021/12/excelweekday.html
回覆刪除https://yixuan1118.blogspot.com/2021/12/excelweekday.html
回覆刪除https://jerry20030703.blogspot.com/2021/12/excelweekday.html
回覆刪除https://d11017212.blogspot.com/2021/12/excel-weel-day.html
回覆刪除https://leepeichieh.blogspot.com/2021/12/excelweeelday.html
回覆刪除https://green1028.blogspot.com/2021/12/excelweekday.html
回覆刪除https://li-you-rou.blogspot.com/2021/12/youtube-video-player.html
回覆刪除https://gold-1-2zhang842.blogspot.com/2021/12/excelweekday.html
回覆刪除https://www.blogger.com/blog/post/edit/2345117422994568907/3178108080475349739
回覆刪除https://www.blogger.com/blog/post/edit/preview/3402766720798119245/6475864354316351588
回覆刪除https://fongcyf.blogspot.com/2022/01/blog-post.html
回覆刪除