explain different formulas with their syntax
Answers
Answered by
2
- SUM. The SUM function. The function will sum up cells that are supplied as multiple arguments. ...
- AVERAGE. The AVERAGE function. ...
- COUNT. The COUNT function. ...
- COUNTA. Like the COUNT function, COUNTA. ...
- IF. The IF function. ...
- TRIM. The TRIM function. ...
- MAX & MIN. The MAX.
Answered by
1
Seven Basic Excel Formulas For Your Workflow
=SUM(number1, [number2], …) ...
=SUM(A2:A8) – A simple selection that sums the values of a column.
=SUM(A2:A8)/20 – Shows you can also turn your function into a formula. ...
=AVERAGE(number1, [number2], …) ...
=AVERAGE(B2:B11) – Shows a simple average, also similar to (SUM(B2:B11)/10)
Similar questions