Студопедия
Случайная страница | ТОМ-1 | ТОМ-2 | ТОМ-3
АрхитектураБиологияГеографияДругоеИностранные языки
ИнформатикаИсторияКультураЛитератураМатематика
МедицинаМеханикаОбразованиеОхрана трудаПедагогика
ПолитикаПравоПрограммированиеПсихологияРелигия
СоциологияСпортСтроительствоФизикаФилософия
ФинансыХимияЭкологияЭкономикаЭлектроника

Financial Functions 3 : Complex Accumulation

Spelling out numbers | Datapilot Revisited | DataPilot Revisited II | Ranking and sorting data I | Conditional summation revisited | Regression analysis I : Basic linear formulas | Regression Analysis II : Basic functions, charting | Regression Analysis III : LINEST | Combining data in cells | Basic Functions: FREQUENCY |


Читайте также:
  1. Advanced Functions: INDIRECT
  2. Basic Functions : CELL
  3. Basic Functions : FIXED
  4. Basic functions : SUBTOTAL
  5. Basic functions : SUMIF
  6. Basic Functions: FREQUENCY
  7. Character functions returning character values

October 7th, 2004

In this example, we consider a more complex accumulation - wherein we are making regular payments as well as earning interest on our initial investment.

Here, we define names for the cells containing the main variables - so that the formulas are more readable.

The purpose of the month-by-month breakdown of the account also serves to confirm the accuracy of our original formula.

Posted


Дата добавления: 2015-08-03; просмотров: 48 | Нарушение авторских прав


<== предыдущая страница | следующая страница ==>
Date & Time : Calculating Dates of Holidays| Data Consolidation 101

mybiblioteka.su - 2015-2024 год. (0.005 сек.)