Excel Quickguide Part. V Create a Formula on Excel 2010 (2/2)

i. Using Functions and nested functions in formulas

Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure. Functions can be used to perform simple or complex calculations.

Structure of a function

Excel Quickguide Part. V Create a Formula on Excel 2010

1. Structure – a function begins with an equal sign followed by the function name, an opening parenthesis, the arguments for the function separated by commas, and a closing parenthesis.

2. Function name. (Click [Shift +F3] to see a list of functions)

3. Arguments can be numbers, text logical values such as True or False, arrays error values such as #N/A or cell references. The argument you designate must produce a valid value for that argument.

ii. Nesting Functions

You may run in to cases where you may need to use a function as one of the arguments of another function. Below is an example that uses nested average function and compares the result with the value 50.

=IF(AVERAGE(F2:F5)>50, SUM(G2:G5),0)

iii. Using references in formulas

A reference identifies a cell or a range of cells on a worksheet, and tells Excel where to look for the values or data you want to use in a formula. You can use references to use data contained in different parts of a worksheet in one formula or use the value from one cell in several formulas. You can also refer to cells on other sheets in the same workbook, and to other workbooks.

The Default Reference Style

Excel Quickguide Part. V Create a Formula on Excel 2010

, , ,

No comments yet.

Leave a Reply