Excel函数公式的组合应用实例精选

用

主要应用函数

IF.CONCATENATE.TEXT.INT.ABS

IF.TEXT,INT.ABS.ROUND

IF.TEXT,.TRUNC.ROUND.RIGHT

CONCATENATE.TEXT.INT.IF.AND.CEILING.OR.FIXED

IF.AND.ISERR.FIND.TEXT.INT.SUBSTITUTE

IF.TEXT.TRUNC.ABS.ROUND.ISERR.FIND.RIGHT.LEFT

IF.TRUNC.AND.ISERR.FIND.TEXT.SUBSTITUTE.ABS

IF.AND.INT.NUBSTRING

IF.ROUND.TEXT.INT

SUBSTITUTE.IF.TEXT.TRUNC.ABS.ROUND.ISERR.FIND.RIGHT.LEFT

INDEX.MATCH.COUNTIF

RANK.COUNTIF.SUM.

RANK

COUNTIF.FREQUENCY.SUM.IF

IF.TEXT.LEN.MID.MOD.RIGHT.LEFT.DATEDIF.TODAY.REPLACE.SUM.ROW

.INDIRECT.DATE.OR.VLOOKUP

TEXT.INDIRECT.ADDRESS.ROW.COLUMN

MID.SMALL.IF.ROW.COLUMN

MID.CHOOSE.FIND

MID.FIND.COUNT.ROW

MID.LENB.LEN

LOOKUP.RIGHT.LEFT.LEN.ROW

TRIM.MID.SUBSTITUTE.REPT.ROW

SEARCH.TRIM.LEFT.MID.LEN

ADDRESS.MATCH.MMULT.ROW.TRANSPOSE.N

SUM

IF.MOD.ROW.INDEX.COLUMN

OFFSET.MOD.ROW.COLUMN.ROUND

OFFSET.CHOOSE.MOD.ROW.COLUMN.ROUND

VLOOKUP.IF.ROW.COUNTIF.INDEX.SMALL.COLUMN

IF.ROW.MATCH.COUNTIF.LOOKUP.VLOOKUP.INDEX

OFFSET.MATCH.COUNTIF.IF.INDEX

LOOKUP.VLOOKUP.IF