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

Basic functions: CHOOSE

Читайте также:
  1. A .Choose the correct item.
  2. Aesthetics satisfies basic human needs and is a source of pleasure
  3. Ask run over break damage frighten choose hurt pay steal sting stop cut off
  4. B) Choose one of the underlined phrases and prepare a one minute report on it.
  5. B) Listen to a dialogue and for questions 1-4 choose the correct variant a, b or c.
  6. B-tree index basic characteristics
  7. BASIC ACCOUNTING CONCEPTS

September 13th, 2005

The CHOOSE function comes in handy when there are a number of options for a particular value based on the result of an expression or result. It saves having to construct a complex formula involving nested-ifs.

In the example below, the CHOOSE function is used to select the text form for the day of the week - according to the numerical value returned by the WEEKDAY function

Posted in Function Tips | No Comments»

Checkerboard shading

September 12th, 2005

A checkerboard shading effect is easily achieved with conditional formatting as shown below. The conditional formatting dialog is invoked with Format - Conditional Formatting

Please review earlier articles on conditional formatting here, here andhere.

When the condition (formula) evaluates to true, then the specified style is applied to the cell. We have seen this before. ISODD is a boolean function so is ideal in this situation.

The resulting pattern…

Posted in Using OpenOffice Calc | No Comments»

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

<== предыдущая страница | следующая страница ==>
Secret StarWars games| Looking up data in tables V
mybiblioteka.su - 2015-2024 год. (0.006 сек.)