Computer Science, asked by mamu76, 1 year ago

what is difference between formula an function

Answers

Answered by ankurawat9944
90
➡Dear mate,
================
➡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



ankurawat9944: wlcm
mamu76: plxr
Answered by Anonymous
88

•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

Similar questions