Year 11 ICT
The IF Function: An IF function contains a pair of brackets and within the brackets three parts, each separated by a comma. An example of an IF function is =IF(A1=5,A2*0.05,"Nodiscount"). The first part is a condition; in this example, it is testing to see if cell A1 contains the number 5. The other two parts are what to do if the condition is met,and what to do if it is not met. If the condition is met a number or label could be placed in the cell, or a reference to another cell, or even a calculation that needs to be performed. The same range of options applies if a condition is not met. In this example, if the condition is met, the result of multiplying the contents of cell A2 by the figure 0.05 is displayed in this cell. If the condition is not met this cell will display the text ‘No discount’.
Nested IF Statement - Spreadsheet Task 6:
Use the same file that you created in Task 5. Change the formulae in cells D3 to D21 to display ‘Not experienced’ if they have less than five years’ experience, ‘Experienced’ if they have five or more years’ experience and ‘Very experienced’ for employees with ten or more years’ experience. Save the document as a pdf showing formulae as [Spreadsheet_Task6_YOURNAME_form] Upload both your files to your Google Drive in the Spreadsheet/Excel folder.
0 Comments
Your comment will be posted after it is approved.
Leave a Reply. |
LINKSPractical Archives
May 2017
Categories
All
|
ContactTelephone:
+974 4450 2172 School Mobile +974 5536 9675 |
|