-is a predefined formula in Excel
-may require arguments as inputs
-can be mixed with other functions and formulas
-different function require different numbers of data needed
Example of a function |
Functions are pre-built, you just need to stack 'em together |
Some Basic Functions
=SUM(A1,Z5)
=PRODUCT(10,B5)
=AVERAGE(B10:C10)
=MAX(A1:Z99)
=NOW()
=IF(A1=A2,B1,C1)
Reference: http://www.changeipadwallpaper.com/wp-content/uploads/1024iPad/3D/Metal%20building%20blocks.jpg
http://moodle.pshs-brc.edu.ph/pluginfile.php/4746/mod_resource/content/0/Functions%20and%20Formula.pdf