1. Differentiate between a formula and function with an example?
Answers
Answered by
1
Answer:
So in summary, a formula is any calculation in Excel, but a function is a pre-defined calculation. =MAX(A1:B20) is a formula containing a function. Mastering the use of functions in formulas is a key skill in learning financial modelling. Happy formula-writing
Answered by
3
Answer:
A formula is statement written by the user to be calculated. ... A function is a piece of code designed to calculate specific values and are used inside formulas. Functions to sum values, calculate a trigonometric cosine, and to calculate the current time are built into excel.
Similar questions