![]() ![]() The first column will represent the name of the employee and the second column is how many guests the employee will bring. ![]() 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. 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. Let's start out with a more simple example and move on to a more complex example. Select the table in the spreadsheet, and click on Menu -> Format -> Autoformat. Instead of manually formatting your tables with different font colors and background, you can use one of the builtin table autoformat as shown below. ![]() 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. The following is the list of some Openoffice calc spreadsheet tips and tricks. 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. 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. And when I work in spreadsheets I work in OpenOffice.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |