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