Excel Functions Published by Giles Male Jan 1, 2021 2:35:00 PM The Excel functions list. Below are the key Excel functions for financial modelling: IF Returns one value for a TRUE result, and another for a FALSE result EOMONTH Returns the last day of the month after adding a specified number of months MAX Returns the largest value from a range of numbers MIN Returns the smallest value from a range of numbers INDEX Returns a value from a range based on the position specified SUMIFS Sum rows that meet specific criteria XLOOKUP Look up values from another table Read more about all of Excel's functions on the Microsoft support page here. Share on Facebook Share on Twitter Share on Linkedin