openoffice calculate difference in a cell

In this example, we will insert a random word from a table range of different cells and insert it in the middle of the sentence.įor the purpose of choosing a value from a random cell we will use the INDEX function which returns a value from a table of range. The resulting sentence should be “This is my 1st sentence”: Make the sentence an executable formula by putting in the beginning of the sentence and surrounding it with double quotes: Step 3. Write the sentence This is my first sentence. We typed 1st, 2nd and 3rd into cells A1, B1 and C1. This is done by putting the formula (or cell number) inside double quotes and surrounding it with “&”: Open a new Calc document and fill in some data. Insert the data from cell A1 in the middle of the sentence. Make the sentence an executable formula by putting “=” in the beginning of the sentence and surrounding it with double quotes: Write the sentence “This is my first sentence”. We typed “1st, 2nd and 3rd” into cells A1, B1 and C1. Open a new Calc document and fill in some data. In this example, we will create a sentence in OpenOffice Calc and insert one of the words as a reference from another cell. We will cover the process of inserting simple formulas that point to another cell, explore random sentence generation methods and word replacement within sentences. You may use either Microsoft Excel or OpenOffice Calc for this purpose.

In this tutorial we will show you how to program simple sentences which contain formulas.

Openoffice calculate difference in a cell