From data to report in one minute or less. Ajelix BI is launched! 🚀 Get started for free.

# Excel Formulas and Functions for Productive Spreadsheets

Ajelix library provides comprehensive resources for learning to use Excel formulas and functions. From basic arithmetic to complex financial analysis, you‘ll find detailed tutorials and explanations to help you master Excel quickly and easily. With our stepbystep guides and resources, you‘ll have the confidence to tackle any project with Excel.

## Text Formulas and Functions

### TODAY Function in MS Excel

Returns the current date.

=TODAY()

### NOW Function in MS Excel

Returns the current date.

=NOW()

### MID Function in MS Excel

Returns a specified number of characters from the middle of a text string.

### SUBSTITUTE Function in MS Excel

Replaces a character or text string with another character or text string in a text string.

### HLOOKUP Function in MS Excel

Looks for a value in the top row of a table, and returns a value in the same column from another row in the table.

## Financial Formulas and Functions

### PM Function in MS Excel

Formula calculates the payment for a loan.

### FV Function in MS Excel

This formula calculates the future value of an investment.

### PV Function in MS Excel

This formula calculates the present value of an investment.

### NPV Function in MS Excel

This formula calculates the net present value of multiple cash flows.

### IRR Function in MS Excel

Internal rate of return of multiple cash flows.

### DDB Function in MS Excel

Depreciation amount for an asset using the double-declining balance method.

### SLN Function in MS Excel

Depreciation amount for an asset using the straight-line method.

### XNPV Function in MS Excel

Net present value of multiple cash flows with dates.

### XIRR Function in MS Excel

Internal rate of return of multiple cash flows with dates.

### CUMIPMT Function in MS Excel

Cumulative interest payments for a loan.

### CUMPRINC Function in MS Excel

Cumulative principal payments for a loan.

### PVIF Function in MS Excel

Present value interest factor.

### FVIFA Function in MS Excel

This formula calculates the future value interest factor.

### NPER Function in MS Excel

This formula calculates the number of periods for a loan.

### RATE Function in MS Excel

This formula calculates the interest rate for a loan.

### DB Function in MS Excel

This formula calculates the depreciation amount for an asset.

### VDB Function in MS Excel

Depreciation amount for an asset using the variable declining balance method.

### XIRR Function in MS Excel

Internal rate of return of multiple cash flows with dates.

### More formulas and functions coming soon!

#### Business Intelligence platform meets AI

Trusted by 150'000 customers around the globe since 2018.

© 2018 - 2024 AJELIX, SIA