Looking up data in tables V

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