Home Excel Functions

# Functions

Learn predefined excel functions used to calculate specific values. Excelbuddy covers dozens of functions with easy to follow demonstrations.

### NPER Function

0
The NPER Function in Excel is a financial function that returns the number of periods for a specified loan. The total periods...

### CUMPRINC Function

0
The CUMPRINC Function in Excel returns the cumulative principal paid on a loan between the start and end period. This is an...

### YEARFRAC Function

0
The YEARFRAC function in Excel returns a decimal value that represents fractional years between two specified dates. Syntax:

### YEAR Function

0
The YEAR function in Excel returns a 4-digit number representing the year component of date. This function allows you to pull out...

### WORKDAY Function

0
The WORKDAY function in Excel takes a date and returns the nearest working day. This is achieved based on user specified values....

### WEEKNUM Function

0
The WEEKNUM Function in Excel will return the week number for a specific date. This function will return an integer from 1...

### FLOOR Function

0
The FLOOR function in Excel rounds a given number down to the nearest specified multiple. Unlike the MROUND function, the FLOOR function...

### TRUNC Function

0
The TRUNC function in Excel returns a truncated number based on a specified number of digits. This specified number of digits is...