Question

what is the difference between function and formula in MS excel​

Answer 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.

Answer 2

Answer:

function means sector of excle and formula is use for loagical condition.

Explanation:

18 basic formula are used for solution of mark list table, slarea table etc.