Functions

Functions

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

Examples:
=PRODUCT(150,.05) 
=SUM(A1,A2) 
=AVERAGE(B1:B10) 
=COUNTA(A1:A100) 
=NOW() 
=MAX(Z2:Z5) 

=MIN(Z4:Z8)

ERRORS
• #DIV/0! 
• #N/A – missing data/found no match 
• #NAME? - undefined range or cell name 
• #NULL! - two ranges that don’t actually intersect 
• #NUM! - pass an invalid argument to a function 
• #REF! - invalid cell reference 
• #VALUE! - argument for a function is of an incorrect data type


Sources:
http://office.microsoft.com
http://spreadsheets.about.com
http://moodle.pshs-brc.edu.ph/