函4第二讲作业补交贴

zh350392718

游客，如果您要查看本帖隐藏内容请回复

vinsky2003

游客，如果您要查看本帖隐藏内容请回复

[em06]

[此贴子已经被作者于2009-10-29 10:45:46编辑过]

好喜欢钱哟

游客，如果您要查看本帖隐藏内容请回复

vinsky2003

刚刚编辑了一下，发现编辑补不了BB。。。

紫色水平线

<p>1组004号补交BB </p><p>&nbsp;</p><p>亏大了。。。[em04]</p>

耐豆子

<p>

游客，如果您要查看本帖隐藏内容请回复

</p>

liufu1964

游客，如果您要查看本帖隐藏内容请回复

耐豆子

补交BB了

耐豆子

游客，如果您要查看本帖隐藏内容请回复

swp0929

<p>1题：=IF(A6*0.0005&lt;1,1,IF(A6*0.0005&gt;20,20,A6*0.0005))</p><p>2题：=IF(TYPE(A20)=1,IF(LEFT(CELL("format",A20))="D","日期","数值"),IF(TYPE(A20)=2,"文本",IF(TYPE(A20)=4,"逻辑值","错误值")))<br/></p><p>3题：=TEXT(DATE(2009,10,MID(CELL("FileName",F2),FIND("]",CELL("FileName",F2))+1,2)),"E-m-d")<br/><span style="FONT-FAMILY: 宋体; COLOR: black; FONT-SIZE: 9pt; mso-ascii-font-family: tahoma; mso-hansi-font-family: tahoma; mso-bidi-font-family: tahoma; mso-ansi-language: en-us; mso-fareast-language: zh-cn; mso-bidi-language: ar-sa;">单击工作表</span><span lang="EN-US" style="FONT-FAMILY: tahoma; COLOR: black; FONT-SIZE: 9pt; mso-ansi-language: en-us; mso-fareast-language: zh-cn; mso-bidi-language: ar-sa; mso-fareast-font-family: 宋体;">“1”</span><span style="FONT-FAMILY: 宋体; COLOR: black; FONT-SIZE: 9pt; mso-ascii-font-family: tahoma; mso-hansi-font-family: tahoma; mso-bidi-font-family: tahoma; mso-ansi-language: en-us; mso-fareast-language: zh-cn; mso-bidi-language: ar-sa;">，按住</span><span lang="EN-US" style="FONT-FAMILY: tahoma; COLOR: black; FONT-SIZE: 9pt; mso-ansi-language: en-us; mso-fareast-language: zh-cn; mso-bidi-language: ar-sa; mso-fareast-font-family: 宋体;">SHIFT</span><span style="FONT-FAMILY: 宋体; COLOR: black; FONT-SIZE: 9pt; mso-ascii-font-family: tahoma; mso-hansi-font-family: tahoma; mso-bidi-font-family: tahoma; mso-ansi-language: en-us; mso-fareast-language: zh-cn; mso-bidi-language: ar-sa;">键，再按工作表</span><span lang="EN-US" style="FONT-FAMILY: tahoma; COLOR: black; FONT-SIZE: 9pt; mso-ansi-language: en-us; mso-fareast-language: zh-cn; mso-bidi-language: ar-sa; mso-fareast-font-family: 宋体;">“31”</span><span style="FONT-FAMILY: 宋体; COLOR: black; FONT-SIZE: 9pt; mso-ascii-font-family: tahoma; mso-hansi-font-family: tahoma; mso-bidi-font-family: tahoma; mso-ansi-language: en-us; mso-fareast-language: zh-cn; mso-bidi-language: ar-sa;">，在</span><span lang="EN-US" style="FONT-FAMILY: tahoma; COLOR: black; FONT-SIZE: 9pt; mso-ansi-language: en-us; mso-fareast-language: zh-cn; mso-bidi-language: ar-sa; mso-fareast-font-family: 宋体;">F2</span><span style="FONT-FAMILY: 宋体; COLOR: black; FONT-SIZE: 9pt; mso-ascii-font-family: tahoma; mso-hansi-font-family: tahoma; mso-bidi-font-family: tahoma; mso-ansi-language: en-us; mso-fareast-language: zh-cn; mso-bidi-language: ar-sa;">单元格输入</span></p><p><span style="FONT-FAMILY: 宋体; COLOR: black; FONT-SIZE: 9pt; mso-ascii-font-family: tahoma; mso-hansi-font-family: tahoma; mso-bidi-font-family: tahoma; mso-ansi-language: en-us; mso-fareast-language: zh-cn; mso-bidi-language: ar-sa;"></span></p><p><span style="FONT-FAMILY: 宋体; COLOR: black; FONT-SIZE: 9pt; mso-ascii-font-family: tahoma; mso-hansi-font-family: tahoma; mso-bidi-font-family: tahoma; mso-ansi-language: en-us; mso-fareast-language: zh-cn; mso-bidi-language: ar-sa;">最近一直很忙 加上流感一直没好 只能回去慢慢看录像了</span></p>