Forum Discussion
When would want to create and solve a formula manually without using a function?
Thnak you so much! This is exactly the explanation I was looking for. I was having trouble explaining the differences between formulas and functionsmathetes
That's more theoretical, not practical question. Function is predefined formula. Next is how it is predefined - by Microsoft and is built into app, or you predefined it by VBA, lambdas, name manager, whatever. And here are discussions starts.
You may find related topic by googling "formula vs function in Excel". Just on of the results
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.
Formula vs Function - Important Differences in Excel to Know (corporatefinanceinstitute.com)