A formula is a user-defined calculation combining operators and functions, while a function is a predefined calculation in Excel designed to perform specific tasks, like SUM or VLOOKUP.