Friday, 16 January 2015

Fuctions

FUNCTION
         – A predefined formula
         – May require arguments as inputs
         – Returns a value
         – May be used together with other functions and other operations

Example
         =PRODUCT(150,8)
         =SUM(A1,A30)
         =AVERAGE(B1:B5)
         =COUNTA(A1:A101)
         =NOW()
         =MAX(Z2:Z7)
         =MIN(Z4:Z12)

(c) Sir Tom

No comments:

Post a Comment