The first column will represent the name of the employee and the second column is how many guests the employee will bring.
#Openoffice calc help software#
To make things easy if the person enters "0" that means they are not bringing a guest (the employee, however, IS required to come) and if they enter "1" that means they are which means that employee equals two attendees. This is how G2 Deals can help you: Easily shop for curated and trusted software Own your own software buying journey Discover exclusive deals on software. We'll do a simple spreadsheet that deals with how many persons each employee will bring to a company picnic. The first example will illustrate a basic IF/ELSE statement that uses only two columns of data. Type it in the cell where you want the answer to appear. When creating formulas in Open Office Calc, you always start by typing the equals sign. This is where we'll enter the basic addition formula. Select the cell C2 and enter 2, then press Enter. Let's start out with a more simple example and move on to a more complex example. Select the cell C1 and enter 3, then press Enter. By sharing a spreadsheet, other users can easily add their data to the spreadsheet. IF entry A is greater than B THEN C is X ELSE C is Y.īut how does one do this? It's actually quite easy. Multiple users support - Encourages collaborative work on spreadsheets. That third columns' entry will depend upon the information in the first two. Let's say you have two columns of numbers and you want to add a third column based on the other two data.
#Openoffice calc help how to#
For instance, did you know that Calc can do If/Else statements? In this spreadsheet tutorial you will learn how to use IF/ELSE statements in OpenOffice Calc. Openoffice Calc holds a lot more bang for the users' buck than you might think. Most people know the ins and outs of spreadsheets, but many don't realize just how powerful spreadsheets can be. This only makes sense, and should only be used, if mode is 0 or FALSE. I hardly ever use Draw, so there may be an easier way to make this shape. You can then copy the shape into your Calc document.
![openoffice calc help openoffice calc help](https://www.shorttutorials.com/openoffice-spreadsheet/images/print-spreadsheet-with-border1.png)
And when I work in spreadsheets I work in OpenOffice. If regular expressions are enabled on the Tools - Options - Calc - Calculate dialog, VLOOKUP will find exact matches treating lookupvalue as a regular expression. It is fairly easy, though not super quick, to draw a rectangle with a hole of the desired size in the middle using the Draw application of OpenOffice.