常用 Excel/Google Sheet 函数备忘
条评论- =VLOOKUP() #Excel
- =ifs(DAYS(TODAY(),Q8)>=730,0,DAYS(TODAY(),Q8)>=365,0.3%)
- =IMPORTXML(url, xpath) #Google Sheet
- =GOOGLEFINANCE() #Google Sheet
- =STOCK(NDQ.US.0) #Tecent Sheet
- =SUMIF(range, criteria, [sum_range])
本文标题:常用 Excel/Google Sheet 函数备忘
文章作者:Michael Chen
发布时间:2022-11-27
最后更新:2022-12-10
原始链接:https://blog.mchen.xyz/post/most-used-excel-functions.html
版权声明:本博客所有文章除特别声明外,均采用 CC BY-NC-SA 3.0 CN 许可协议。转载请注明出处!