Excel Functions by Category

Excel functions listed by category.

Below are the key Excel functions for financial modelling by category:

Logical functions

IF   Returns one value for a TRUE result, and another for a FALSE result

Lookup and reference functions

XLOOKUP Look up values from another table

INDEX Returns a value from a range based on the position specified

Date and time functions

EOMONTH  Returns the last day of the month after adding a specified number of months

Statistical functions

MAX  Returns the largest value from a range of numbers

MIN  Returns the smallest value from a range of numbers

Maths  functions

SUMIFS Sum rows that meet specific criteria

Read more about all of Excel's functions on the Microsoft support page here.