SUM
Find the sum of the specified cells
example
=SUM(A1:A3)
version 3.0.0 ~
=SUM(A1,A2,A3)
AVERAGE
Finds the average value of the specified cell
example
=AVERAGE(A1:A3)
MIN
Displays the minimum value of the specified cell
example
=MIN(A1:A3)
MAX
Displays the maximum value of the specified cell
example
=MAX(A1:A3)
ROUND
Round the specified cell to the nearest whole number
example A1=3.1415926535897
=ROUND(A1,-1) // 3
=ROUND(A1,-2) // 3.14
example A1=15980
=ROUND(A1,0) // 15980
=ROUND(A1,-1) // 15980
=ROUND(A1,-2) // 16000
=ROUND(A1,-3) // 16000
=ROUND(A1,-4) // 20000