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. 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.
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 kommentar(er)
