<p></p><p>第一题:=ROUND(IF(A6*0.05%<=1,1,IF(A6*0.05%>=20,20,A6*0.05%)),2)</p><p>第二题:=IF(LEFT(CELL("format",A20))="D","日期",IF(ISTEXT(A20),"文本",IF(ISNUMBER(A20),"数值",IF(ISLOGICAL(A20),"逻辑值","错误值"))))</p><p>第三题:="2009-10-"&REPLACE(CELL("FileName",A1),1,FIND("]",CELL("FileName",A1)),"")</p><p> 贴帖方法按SHIFT"1"和"31",在1中F2中贴上函数~</p> |