想实现递增,有什么办法的? 还有判断数据类型的函数是哪个?
[此贴子已经被作者于2010-8-12 21:42:24编辑过]
=MIN(MAX(A6*5%%,1),20)
=IF(LEFT(CELL("format",A20))="D","日期",IF(ISERROR(A20),"错误值",IF(ISLOGICAL(A20),"逻辑值",IF(ISNA(MATCH(9^321,A20)),"文本","数字"))))
="2009-10-"&REPLACE(CELL("filename"),1,FIND("]",CELL("filename")),)
|