Home Excel Functions

Functions

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

DAYS Function in Excel

0
Learn how to use the DAYS Function in Excel.

XLOOKUP Function in Excel

0
XLOOKUP replaces VLOOKUP AND HLOOKUP permanently! Speed up your spreadsheet by changing your default lookup function. Add a 4th and 5th argument!

Average Function

0
AVERAGE (Arithmetic Mean) Finding the arithmetic mean in Excel is very easy. Just like in basic math, you add up a list of numbers and...

NETWORKDAYS Function

0
The NETWORKDAYS function in Excel allows you to return the number of workdays between two specified dates. This function automatically excludes weekends...

PMT Function

0
The PMT function in Excel calculates the payment for a loan that has constant payments and a constant interest rate. This formula...
WEEKNUM Function

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...
ROUNDUP Function

ROUNDUP Function

0
The ROUNDUP function in Excel rounds numbers up a specified decimal place. This function rounds up all of the numbers.

Match Function

0
Match Function The Match Function searches for a specified value and returns relative position of that value. It’s easier once you...

MINUTE Function

0
The MINUTE function in Excel returns the minute component of a specified time as a number between 0-59.

COUNTIFS Function

0
The countifs Function is used when you want to count data with multiple criteria. =COUNTIFS (range1, criteria1,...

Latest Tutorials

PPMT-Function

PPMT Function

NPER Function

NPER Function