Over 1.8 million professionals use CFI to learn accounting, financial analysis, modeling and more. Start with a free account to explore 20+ always-free courses and hundreds of finance templates and cheat sheets.
A Formula is an equation designed by a user in Excel, while a Function is a predefined calculation in the spreadsheet application. This guide will walk you through Formula vs Function in Excel so you know exactly what the similarities and differences are.
Excel enables users to perform simple calculations, such as finding totals for a row or column of numbers. Formulas and functions can be useful in more complex situations, including calculating mortgage payments, solving engineering or math problems, and creating financial models.
Formulas are created equations, while functions are pre-defined calculations on a spreadsheet.
When an Excel user types an = sign in an Excel cell, he or she is starting to create a formula.
When an Excel user types an = sign followed by a predesigned set of letters or clicks on the Fx button in the formula bar, a function begins to be implemented.
Examples of a Formula
When a user types an equals sign in a cell, they are starting to create a formula.
Examples of a formula include:
=B7+B8-(4*2)+1 [see screenshot below]
Examples of a Function
When a user types an equals sign followed by a predefined set of letters (or clicks on the Fx button in the formula bar), a function begins to be implemented.
=AVERAGE(F4:F8) [see screenshot below]
Examples of a Formula and Function
It doesn’t just need to be a case of formula vs function. Users can combine the two to create an even more powerful analysis.
Examples of the two combined are:
Formula vs Function in Practice
In common business practice, Excel users use the terms formula and function almost interchangeably. From a communication and comprehension perspective, there’s not a big difference. Just know that technically, a function is a piece of code that executes a predefined calculation, while a formula is something you create yourself.
Thank you for reading this CFI guide to understanding Formula vs Function in Excel.
CFI is the official provider of the global Financial Modeling & Valuation Analyst (FMVA)™ certification program, designed to help anyone become a world-class financial analyst. To keep advancing your career, the additional CFI resources below will be useful:
Take your learning and productivity to the next level with our Premium Templates.
Upgrading to a paid membership gives you access to our extensive collection of plug-and-play Templates designed to power your performance—as well as CFI's full course catalog and accredited Certification Programs.
Already have a Self-Study or Full-Immersion membership? Log in
Access Exclusive Templates
Gain unlimited access to more than 250 productivity Templates, CFI's full course catalog and accredited Certification Programs, hundreds of resources, expert reviews and support, the chance to work with real-world finance and research tools, and more.