1 / 8

Advanced Functions – Obj. 4.01

Advanced Functions – Obj. 4.01. Advanced Functions are used in higher-level operations , such as conditional and comparison equations to compute interest rates, due dates and payment terms, and financial projections. Types of Advanced Functions. IF Statement Functions Date Functions

irisa
Download Presentation

Advanced Functions – Obj. 4.01

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Advanced Functions – Obj. 4.01 Advanced Functions are used in higher-level operations, such as conditional and comparisonequations to compute interest rates, due dates and payment terms, and financial projections.

  2. Types of Advanced Functions • IF Statement Functions • Date Functions • Lookup Functions • ListFunctions • Count Functions

  3. IFStatements IF Statements are conditional operators. • Results are returned IF the data specified in an equation meets conditions set by the formula • IFstatements can be written to carry out an action Example: IF a value in a cell is greater than or equal to another value, insert the word “Pass” in a cell. Example: The answer is one value IF a condition you specify evaluates to TRUE and returns another value IFthe condition evaluates to FALSE.

  4. Date Functions DateFunctions are used to calculatea period of time. Types of DateFunctions: • NOW– returns the current date (2)DAYS360– calculates the difference in days between 2 dates Examples: • The number of days that have elapsed since a value was entered into a specific cell • To calculate a 30 day due date for a record of spreadsheet invoices

  5. Lookup Functions A Lookup function is used to compare a cell value to an ARRAY of cells and return a value that matches the location of the value in the array. (Note: the valuesMUST be placed in Ascendingorder) Types of LookupFunctions: (1) Lookup – used for two column vectors (2) VLookUp – used when there are more than two columns in the array (lookup table)

  6. List Function A List Function is used to: • Assist in organizing spreadsheet information. • Create a more user-friendly spreadsheet atmosphere. • Control the size or content of data entries. • Filter for specific content within a list.

  7. List Function Types of Lists: (a) Validated • A validatedlistlimits data entry to specific choices programmed into the function (b) Non-Validated • A non-validatedlistallows additional entries other than those provided in the drop-down menu. • Example: displaying only the Southeast region vice presidents from a spreadsheet instead of displaying all of the vice presidents

  8. Count Function The COUNTFunction is used toreturn the number of cells in a range. Types of CountFunctions: • Count – returns the number of cells in a rangethat contain numbers • CountA – returns the number of cells in a rangethat contain any value/label • Countlf – returns the number of cells that meet a condition set forth in a formula.

More Related