Functions in Excel 2013 A function is a predefined formula that performs calculations using specific values in a particular order. Excel includes many common functions that can be useful for quickly finding the sum , average , count , maximum value , and minimum value for a range of cells. In order to use functions correctly, you'll need to understand the different parts of a function and how to create arguments to calculate values and cell references The parts of a function A function must be written a specific way, called syntax . The basic syntax for a function is the equals sign (=) , the function name (SUM, for example), and one or more arguments . Arguments contain the information you want to calculate. The function in the example below would add the values of the cell range A1:A20. Working with arguments Arguments can refer to both individual cells and cell ranges and must be enclosed within parentheses . You can include one argumen
Comments
Post a Comment