1 / 10

Functions

Functions. Computer Applications. What is a function formula?. Special formula that does NOT use operators (e.g. +, -, *, etc.) to calculate a result Performs complex calculations in mathematics, trigonometry, statistics, logic, accounting and finance.

azure
Download Presentation

Functions

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. Functions Computer Applications

  2. What is a function formula? • Special formula that does NOT use operators (e.g. +, -, *, etc.) to calculate a result • Performs complex calculations in mathematics, trigonometry, statistics, logic, accounting and finance. • Made of three parts: 1. Equals sign 2. Function name 3. Argument • Argument: value, cell reference, range or text that acts as an operand in the function formula

  3. Mathematical and Trigonometric Functions • Square Root • SQRT(number) • Example: =SQRT(A13) or =SQRT(22) • Round • Displays the rounded value of a number to the number of places designated by the second argument • Example: =ROUND(122.778, 1) would display 122.8

  4. One Last Mathematical Function and Some Statistical Functions Too! • Natural Log (last math function) • =LN(50) would display 1.69897 • Average (on to statistical stuff) • Displays the average of a range of cells • Example: =AVERAGE(E4:E9) • Count • Counts the number of cells that have something typed in them • Example: =COUNT(E4:E9) => Result would be 6 if all cells had something in them, 5 if one was blank

  5. More Statistical Functions • Maximum • Displays the largest number in a range • Example: =MAX(A2:B5) • Minimum • Displays the smallest number in a range • Example: =MIN(A1, D5, Z8, BB2) • Standard Deviation and Variance • Example: =STDEV(A2, B7) • Example: =VAR(F1:F9)

  6. Financial Functions • Future Value • What will a monthly investment of $50 be worth in 10 years if a savings account pays 1% APR? • FV(rate, nper, pmt) • rate is the interest rate. If you make yearly payments, leave it as is (e.g. 1%). If you make monthly payments, divide the rate by 12.

  7. Future Value (cont.) • nper is the number of periods. If you make yearly payments, your period stays as is (e.g. 10 years). If you make monthly payments, you multiply by 12. • pmt is the amount that is going out of your pocket. It does not need to be modified for years or months. • =FV(.01/12, 10*12, -50)

  8. Present Value and Payment • “How much car can I afford?” • You know you can afford $200/month car payment. The going rate for car loans is 5 years at 5.5% APR. • PV(rate, nper, pmt) • =PV(.055/12, 5*12, -200) • Payment • What will be the payment on a $20,000 car with a loan of 5 years, 5.5% APR? • PMT(rate, nper, pv) • =PMT(.055/12, 5*12, -20000)

  9. Date, Time, and Text Functions • Date • Displays the date in a variety of formats, such as 12/17/03 or December 17, 2003 • =DATE(year, month, day) • Now • Displays the current date or time based on the computer’s clock • =NOW() will result in 5/23/03 10:05

  10. Repeat • Displays the text (first argument) a specified number of times (second argument) • Example: =REPT(B6, 4) • Say the number 3 was in B6 • This cell would display 3333

More Related