CSE 2111 Study Guide - Final Guide: Interest, Balloon Payment Mortgage, Financial Transaction

• School: Ohio State University
• Department: Computer Science & Engineering
• Course: CSE 2111
• Professor: Clair Farris

Document Summary

Use when your comparison values are located in a column to the left of the data you want to find. Finds an entry from a vertical array based on a criteria. Use when your comparison values are located in a row across the top of a table of data, and you want to look down a specified number of rows. Returns a value you specify if a formula evaluates to an error, otherwise it returns the result of the formula. Present value what you get/pay at the beginning of the financial transaction. Future value what you are going to get or what you will have to pay at the end of the financial transaction. It remains constant over the life of annuity. Formula(lookup_value, lookup range, # of columns from the left that you want the value returned, true/false) False: finds an exact match in your table array.