一些好用的 MSO Excel 函数

Revision as of 09:53, 29 September 2025 by Mwroot (talk | contribs) (Created page with "本文介绍一些好用的 MSO excel 函数。日期注意用英引号扩起来。 ; 计算两个日期之间差了几年 : =YEARFRAC("2018/9/30","2024/7/1",1) ; 对几年取整，舍弃小数部分 : =TRUNC(sth) ; 往后推算 5 年是哪个日期 : =EDATE("2018/9/30",5*12) ; 保留两位小数点 : =round(a1, 2) Category:MicroSoft Office")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

本文介绍一些好用的 MSO excel 函数。

日期注意用英引号扩起来。

计算两个日期之间差了几年: =YEARFRAC("2018/9/30","2024/7/1",1)

对几年取整，舍弃小数部分: =TRUNC(sth)

往后推算 5 年是哪个日期: =EDATE("2018/9/30",5*12)

保留两位小数点: =round(a1, 2)

Retrieved from "https://qingliezhiquan.com/index.php?title=一些好用的_MSO_Excel_函数&oldid=7877"