Ron Mikhael Surara

Ron Mikhael Surara

Saturday, January 10, 2015

What I Learned in CompSci #25: Functions

Function
     -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