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

Filling a Cell Range with a Series

Conditional summation revisited | Regression analysis I : Basic linear formulas | Regression Analysis II : Basic functions, charting | Regression Analysis III : LINEST | Combining data in cells | Date & Time : Calculating Dates of Holidays | Financial Functions 3 : Complex Accumulation | Data Consolidation 101 | Basic Functions: FREQUENCY | Advanced Functions: INDIRECT |


Читайте также:
  1. Descriptive Psychology W. Dilthey (1833-1911) and E. Spranger (1882-1963)
  2. Filling a multiplication chart
  3. For index in bv’range loop

February 24th, 2005

A quick way to fill a range of cells with a series of values that increase/decrease in a geometric fashion.


Let us consider the simple example below. We wish to complete the series of values atrting at B3 (shaded).

The Fill Series dialog is invoked with Edit - Fill - Series as shown below.

OOo Calc makes it’s best guess regarding the continuation of the series.

In this example, we will elave everything at the default settings and close the dialog with OK

The completed series! Next,we will look at handling dates.


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


<== предыдущая страница | следующая страница ==>
Basic functions : SUBTOTAL| Basic Functions : CELL

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