tailieunhanh - how to do everything with ms office excel 2003 phần 5

vào ngày hiện tại trong một tế bào, và vào ngày hiện tại và thời gian, trong một hình thức tự động cập đổi chuỗi văn bản để nối tiếp tương ứng của nóngày. Theo mặc định, Excel sẽ hiển thị kết quả với định dạng ngày, | 158 How to Do Everything with Microsoft Office Excel 2003 Function What It Returns TODAY Current date formatted as a date NOW Current date and time formatted as a date and time WEEKDAY Weekday for the specified day as a serial number between 1 Sunday and 7 Saturday TABLE 7-1 Excel s Date and Time Functions continued Here are three examples of using the date and time functions TODAY enters the current date in a cell and NOW enters the current date and time in an automatically updating form. DATEVALUE 2004-4-1 converts the text string 2004-4-1 to its corresponding serial date. By default Excel displays the result with Date formatting but you can apply other cell formatting for example you might choose to display the serial number for the date . HOUR 11 45 PM returns 23 the hour derived from 11 45 . Financial Functions Excel includes 16 financial functions explained in Table 7-2 for common calculations and the Analysis ToolPak one of Excel s add-ins that you can load by choosing Tools Add-Ins adds about three dozen extra financial functions for more arcane calculations. Function What It Returns DB Depreciation using the fixed-declining balance method DDB Depreciation using the double-declining balance method or other method FV Future value of an investment IPMT Interest payments for an investment for a specified period IRR Internal rate of return for cash flows MIRR Modified internal rate of return for cash flows ISPMT Interest paid for an investment over a specified period NPER Number of periods for an investment NPV Net present value of an investment PMT Payment for a loan PPMT Payment on the principal for an investment PV Present value of an investment TABLE 7-2 Excel s Financial Functions CHAPTER 7 Perform Calculations with Functions 159 Function What It Returns RATE Interest rate per period of an investment SLN Straight-line depreciation for an asset SYD Sum-of-years digits depreciation for an asset VDB Depreciation for an asset using the double-declining .