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.


Back to Blog