EXCEL財務函數(shù)

• ACCRINT函數(shù)
• ACCRINTM函數(shù)
• AMORDEGRC函數(shù)
• AMORLINC函數(shù)
• COUPDAYBS函數(shù)
• COUPDAYSNC函數(shù)
• CUMIPMT函數(shù)
• CUMPRINC函數(shù)
• DB函數(shù)
• DDB函數(shù)
• FV函數(shù)
• IPMT函數(shù)
• IRR函數(shù)
• ISPMT函數(shù)
• MIRR函數(shù)
• MIRR函數(shù)
• NPER函數(shù)
• NPV函數(shù)
• PMT函數(shù)
• PPMT函數(shù)
• PRICE函數(shù)
• PV函數(shù)
• RATE函數(shù)
• SLN函數(shù)
• SYD函數(shù)
• VDB函數(shù)
• XIRR函數(shù)
• XNPV函數(shù)
• YIELD函數(shù)

EXCEL邏輯函數(shù)

• AND函數(shù)
• FALSE函數(shù)
• IF函數(shù)
• IFS函數(shù)
• IFERROR函數(shù)
• IFNA函數(shù)
• NOT函數(shù)
• OR函數(shù)
• SWITCH函數(shù)
• TRUE函數(shù)
• XOR函數(shù)

EXCEL文本函數(shù)

• ASC函數(shù)
• BAHTTEXT函數(shù)
• CHAR函數(shù)
• CLEAN函數(shù)
• CODE函數(shù)
• CONCAT函數(shù)
• CONCATENATE函數(shù)
• DOLLAR函數(shù)
• EXACT函數(shù)
• FIND函數(shù)
• FINDB函數(shù)
• FIXED函數(shù)
• FORMULATEXT函數(shù)
• LEFT函數(shù)
• LEFTB函數(shù)
• LEN函數(shù)
• LENB函數(shù)
• LOWER函數(shù)
• MID函數(shù)
• MIDB函數(shù)
• NUMBERSTRING函數(shù)
• PROPER函數(shù)
• REPLACEB函數(shù)
• REPLACE函數(shù)

EXCEL日期和時間函數(shù)

• DATE函數(shù)
• DATEDIF函數(shù)
• DATESTRING函數(shù)
• DATEVALUE函數(shù)
• EDATE函數(shù)
• EONONTH函數(shù)
• HOUR函數(shù)
• MINUTE函數(shù)
• DAYS360函數(shù)
• day函數(shù)
• MONTH函數(shù)
• NETWORKDAYS函數(shù)
• NETWORKDAYS.INTL函數(shù)
• NOW函數(shù)
• DAYS函數(shù)
• SECOND函數(shù)
• TIME函數(shù)
• TIMEVALUE函數(shù)

EXCEL查找和引用函數(shù)

• ADDRESS函數(shù)
• AREAS函數(shù)
• CHOOSE函數(shù)
• COLUMNS函數(shù)
• COLUMN函數(shù)
• FORMULATEXT函數(shù)

EXCEL數(shù)字和三角函數(shù)

• ABS函數(shù)
• ACOS函數(shù)
• ACOSH函數(shù)
• ACOT函數(shù)

EXCEL統(tǒng)計函數(shù)

• AVEDEV函數(shù)
• AVERAGE函數(shù)

EXCEL工程函數(shù)

EXCEL信息函數(shù)