Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community!

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Data Analysis Spreadsheet Basics Getting Started With Spreadsheets Calculating Totals With SUM

Difference between formula and function?

What is the difference between a formula and a function?

1 Answer

Michael Hulet
Michael Hulet
47,909 Points

A function is a bit of functionality built into your spreadsheet application, like SUM, for example. A formula is what you enter into a particular cell in order to calculate its value based on the value of other cells (or some other data). A formula is probably comprised of one or more functions working together