About Lesson
Difference between a formula and a function?
Often used interchangeably
Formula: any calculation in Excel
=A1+A2+A3
Function: pre-defined calculation in Excel
=SUM(A1:A3)
For our purposes, we will focus on functions, as these are tools within Excel to increase efficiency
You can develop any formula you need to fit your calculation
Qs: Does anyone know the difference between a formula and a function?
To be honest, I didn’t know until recently. For our purposes, we’ll use these interchangeably but understand that when you are getting into more complex or advanced excel use, there is a difference between the two