EXCEL中的隐秘函数.xls

其他 DATEDIF举例 DATEDIF 旧版函数 A1.R1C1 ABSREF ACTIVATE ACTIVATE.NEXT ACTIVATE.PREV ACTIVE.CELL ACTIVE.CELL.FONT ADD.ARROW ADD.BAR ADD.CHART.AUTOFORMAT ADD.COMMAND ADD.MENU ADD.OVERLAY ADD.TOOL ADD.TOOLBAR ADDIN.MANAGER ALERT ALIGNMENT ANOVA1 ANOVA2 ANOVA3 APP.ACTIVATE.MICROSOFT APP.ACTIVATE APP.MAXIMIZE APP.MINIMIZE APP.MOVE APP.RESTORE APP.SIZE APP.TITLE APPLY.NAMES APPLY.STYLE ARGUMENT ARRANGE.ALL ASSIGN.TO.OBJECT ASSIGN.TO.TOOL ATTACH.TEXT ATTACH.TOOLBARS AUTO.OUTLINE AXES BEEP BORDER BREAK BRING.TO.FRONT CALCULATE.DOCUMENT CALCULATE.NOW CALCULATION CALLER CANCEL.COPY CANCEL.KEY CELL.PROTECTION CHANGE.LINK CHART.ADD.DATA CHART.TREND CHART.WIZARD CHECK.COMMAND CLEAR CLEAR.OUTLINE CLEAR.ROUTING.SLIP CLOSE CLOSE.ALL COLOR.PALETTE COLUMN.WIDTH COMBINATION CONSOLIDATE CONSTRAIN.NUMERIC COPY COPY.CHART COPY.PICTURE COPY.TOOL CREATE.NAMES CREATE.OBJECT CUSTOM.REPEAT CUSTOM.UNDO CUT DATA.DELETE DATA.FIND DATA.FIND.NEXT DATA.FIND.PREV DATA.FORM DATA.LABEL DATA.SERIES DEFINE.NAME DEFINE.STYLE DELETE.ARROW DELETE.BAR DELETE.CHART.AUTOFORMAT DELETE.COMMAND DELETE.FORMAT DELETE.MENU DELETE.NAME DELETE.OVERLAY DELETE.STYLE DELETE.TOOL DELETE.TOOLBAR DEMOTE DEREF DESCR DIALOG.BOX DIRECTORY DISABLE.INPUT DISPLAY DOCUMENTS DUPLICATE ECHO EDIT.COLOR EDIT.DELETE EDIT.OBJECT EDIT.REPEAT EDIT.SERIES EDIT.TOOL EDITION.OPTIONS ELSE ELSE.IF EMBED ENABLE.COMMAND ENABLE.TIPWIZARD ENABLE.TOOL END.IF ENTER.DATA ERROR ERRORBAR.X ERRORBAR.Y EVALUATE EXEC EXECUTE EXPON EXTEND.POLYGON EXTRACT FCLOSE FILE.DELETE FILES FILL.AUTO FILL.DOWN FILL.GROUP FILL.LEFT FILL.RIGHT FILL.UP FILTER FILTER.ADVANCED FILTER.SHOW.ALL FIND.FILE FONT FONT.PROPERTIES FOPEN FOR FOR.CELL FORMAT.AUTO FORMAT.CHART FORMAT.CHARTTYPE FORMAT.FONT FORMAT.LEGEND FORMAT.MAIN FORMAT.MOVE FORMAT.NUMBER FORMAT.OVERLAY FORMAT.SHAPE FORMAT.SIZE FORMAT.TEXT FORMULA.ARRAY FORMULA.CONVERT FORMULA.FILL FORMULA.FIND FORMULA.FIND.NEXT FORMULA.FIND.PREV FORMULA.GOTO FORMULA.REPLACE FOURIER FPOS FREAD FREADLN FREEZE.PANES FSIZE FTESTV FULL FULL.