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