数值公式应用公式的结果20101213 =TEXT(A1,"0000-00-00")2010-12-13 19990103 =TEXT(A2,"0000-00-00")1999-01-03 19980512 =TEXT(A3,"0000-00-00")1998-05-12 19971009 =TEXT(A4,"0000-00-00")1997-10-09
0 =TEXT(A5,"正数；负数；零")零
11 =TEXT(A6,"正数；负数；零")正数
-1.245 =TEXT(A7,"正数；负数；零")负数
-1.245 =TEXT(A8,"00.##")-01.25text函数什么意思
-1.245 =TEXT(A9,"#.0000")-01.25 324.567 =TEXT(A10,"#.0000")324.57 19210701 =TEXT(A11,"0000年00月00日")1921年07月01日
87 =TEXT(A12,"[> =85]优秀;[> =60]及格；不及格")优秀
61 =TEXT(A13,"[> =85]优秀;[> =60]及格；不及格")及格
54 =TEXT(A14,"[> =85]优秀;[> =60]及格；不及格")不及格
99 =TEXT(A15,"[> =85]优秀;[> =60]及格；不及格")优秀

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。