Home » Excel » Functions » Page 7

# Functions

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

## DATEVALUE Function

The Excel DATEVALUE function is used to convert a date in Excel to text. =DATEVALUE (date_text) date_text – Date in text format. In the example below, we convert …

## COUNTIF Function

The COUNTIF Function in Excel is extremely useful when dealing with large data sets. Here is a basic example of house to use this function. Below we are …

## PMT Function

The PMT function in Excel calculates the payment for a loan that has constant payments and a constant interest rate. This formula will not work with a flexible …

## SUMIFS Function

The SUMIFS function in Excel sums up particular cells based upon multiple criteria. The Sumif Function is only able to use one criteria. Criteria is specified using logical …

## SUMIF Function

The SUMIF function in Excel sums up particular cells based upon certain criteria. Criteria is specified using logical operators. Common operators are >,<,<>, and =. Wildcard operators can …

## If Function

The IF Function in excel is a logical test that can be run using specific conditions. This logical test returns one value for “True” and another for “False”. …

## AverageIFS Function

Finding the arithmetic mean in Excel is very easy.  In this example, we will be using the AVERAGEIFS function. We will be finding the average of a data …

## AVERAGEIF Function

AVERAGEIF (Arithmetic Mean) – Single Criteria IF statement Use the AVERAGEIF Function to find the arithmetic mean in Excel while defining a specific criteria.  In this example, we …

## Average Function

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 divide by sum …

## Autosum Function

Autosum Function Overview The AutoSum Function is by far one of the most useful features in all of Excel. Just about every spreadsheet can benefit from incorporating the …

Scroll to Top