Starting with a fairly basic example, the IF/ELSE statement can be used for very basic employee wages. The structure of the IF/ELSE statement (for the purposes of LibreOffice Calc) will be =IF(A=B C D), which translates to IF A = B THEN C, ELSE D. The only trick is knowing the correct formula to use. The goal is if the number in Column A is greater than the number in Column B, then the resultant number in Column C will be 20, otherwise the resultant number will be 10.īut how can this be translated into a spreadsheet entry? Actually it’s not that difficult. Here’s an example using numbers following the above statement. So if A is greater than B the results of C will be X, otherwise the results of C will be Y. IF A is greater than B THEN C is X ELSE C is Y The goal is to add a third column that is based on the comparison of the data in the individual cells of the other two columns. Let’s say there is a spreadsheet with two columns of numbers.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |