difference between functions and formula
Answers
Answered by
4
Afunctionis an argument in aformula. A formula performs calculationsor other actions on the data in your worksheet.For example, in the formula=MATCH(7,A1:A3,0),MATCHis the function.Formulas can have multiple functions, callednested functions:=IF(A1="10x12",120,IF(A1="8x8",64,IF(A1="6x6",36))). In this formula,all the functions are the same:IF.You can also have nested functions ofdifferentfunctions, such as:=INDEX(C3:C7,MATCH
Answered by
3
Answer:
Explanation:
In Excel, a formula is a mathematical equations used to calculate a value and must begin with an (=) sign.
A function is a predefined formula that performs calculating by using specific values in a particular order.
Similar questions