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

Looking up data in tables V

Читайте также:
  1. Cumin spiced pork tenderloin with root vegetables
  2. Each column in table 1, Showing branches, is to be found in tables 2 and 3.
  3. Fruits and Vegetables
  4. IX. LOOKING AFTER THE TWENTY PERCENT
  5. John and Helen are friends. They are in John’s room now, looking at the photograph on the wall.
  6. Lecture 7. Transformations from ER diagrams to SQL Tables
  7. Looking at More, Looking Deeper

April 6th, 2005

Here is another simple application of the VLOOKUP function.
Consider a sales person who gets paid commissionson sales based on a sliding scale.

For sales up to $50, a comission of 25% is paid, between $50 and $100, the commission drops to 22.5% - and so on. By using the lookup table and VLOOKUP, the correct rate of commission can be applied to each sale.

Posted in Function Tips | No Comments»

Combining data in cells

March 30th, 2005

A few examples showing how data from multiple cells can be combined - as well
as how data can be combined with text and with extra formatting. A useful
function is the TEXT()( function. We will look at some examples.

A few examples showing how data from multiple cells can be combined - as well
as how data can be combined with text and with extra formatting. A useful
function is the TEXT()( function. We will look at some examples.

It is straightforward to merge text data from different cells. The
& - Ampersand operator is used to concatenate text from different
sources. This is shown below in C3

Numerical data can also be combined with text using the & operator - such
as in C6 below.

For special data types - such as dates and curencies, we need to use the
TEXT() function, which returns a value converted to text with a
specified format. A few examples are shown in C9 and C12

Rounding functions I

March 28th, 2005

There are almost a dozen available rounding functions available in OOo Calc. We will first look at ROUND(), ROUNDUP() and ROUNDDOWN()
Read the rest of this entry»

Posted in Function Tips | 1 Comment»


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


<== предыдущая страница | следующая страница ==>
Basic functions: CHOOSE| Теоретична частина

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