Please enable JavaScript.
Coggle requires JavaScript to display documents.
Function (advantage (Saves time writing, Simplifies complex calculations,…
Function
advantage
Saves time writing
Simplifies complex calculations
Faster execution
Less chance of typographical errors
Fewer characters in the formula bar
The general format
=Function name(arguments)
The SUM Function
SUM(range) or SUM(num1, num2, …)
Arguments of a SUM function
Valid Range Arguments
A1:A4 - Range along a column
A1:D1 - Range along a row
A1:D4 - A two-dimensional range
A1, D3:D5, 7 - non-contiguous cells*
Function Wizard
A short-cut to all the
functions in excel
The Round Function changes the precise value
of a number, not just its display
Syntax: Round (number, num_digits)
= Round (24.44,1) results in the value 24.4
Use the COUNTIF Function
=COUNTIF(B5:B8, “H”)
The SUMIF Function sums the values in a
range that meet a specific criteria
SUMIF(range, criteria, sum-range)
Use the AVERAGEIF function to average values
=AVERAGEIF($B$3:$B$9,$B13,C$3:C$9)