what is difference between formula an function
Answers
================
➡Here is your answer,
================
1⃣A formula is statement written by the user to be calculated. Formulas can be as simple or as complex as the user wants. A formula can contain values, references to cells, defined names, and functions.
➡All formulas must start with the equals sign. =1+2+3
2⃣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. Additional functions can be defined using Visual Basic.
➡Functions are typed alongside parenthesizes, where in the arguments if any are listed in between. To use functions in a formula, for example
=COS(3.14) will return the calculated cosine. =NOW() returns the current time. =SUM(1+2+3) *2 will multiply the sum by 2
========================
Hope it helps you and don't into these frienship occasion
=======================
Thank you friend
•What is difference between
formula and function?
FORMULA :
1) A formula is statement written by
the user to be calculated.
2) Formulas can be as simple or as
complex as the user wants.
3) A formula can contain values,
references to cells, defined
names, and functions.
4) All formulas must start with the
equals sign. =1+2+3
FUNCTION :
1) A function is a piece of code
designed to calculate specific
values and are used inside
formulas.
2) Functions to sum values,
calculate a trigonometric cosine,
and to calculate the current time
are built into excel.
3) Additional functions can be
defined using Visual Basic.
4)Functions are typed alongside
parenthesizes, where in the
arguments if any are listed in
between.
***To use functions in a formula, for
example
=COS(3.14) will return the
calculated cosine.
=NOW() returns the current t
time.
=SUM(1+2+3) *2 will multiply
the sum by 2