B ITM 215 Information Lecture 13: Specialized Functions

• School: SUNY Albany
• Department: Information Technology Management
• Course: B ITM 215 Information
• Professor: Ethan Sprissler

Document Summary

Itm 215 - lecture 13 - specialized functions. If function: performs different actions based on whether the logical test is true or false, has three arguments: logical_test, value_if_true, and value_if_false. Example: if(cid:894)a6>40, (cid:862)overti(cid:373)e(cid:863), (cid:862)(cid:374)o overti(cid:373)e(cid:863)(cid:895: nested function function that is embedded within an argument of another function. Match returns the position of a value in a list. Lookup_value value that you want to find in the array or list. Lookup_array range of contiguous cells that contain potential lookup values. Match_type 1, 0, or 1 to indicate which value to return. Index returns a value or the reference to a value within a range based on x and y coordinates. Index function has three arguments: array one or more ranges, row_num identifies the row number within the array range, column_num identifies the column within the reference that contains the desired value.