1 / 5

IF Statement

IF Statement. Click on the link below http://www.free-training-tutorial.com/if-statement.html Very good site to learn if statement, look at the video and text for more information. Once you are ok with it lets try a task. Task. Download IF.xlsx from website.

bree
Download Presentation

IF Statement

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. IF Statement

  2. Click on the link below • http://www.free-training-tutorial.com/if-statement.html • Very good site to learn if statement, look at the video and text for more information. • Once you are ok with it lets try a task

  3. Task • Download IF.xlsx from website. • You need to implement if statement for the following. If more than 5 units are sold then target is met with ‘yes’ else ‘no’ • It is best typing the formula. Another alternative is using the ‘fx’ button; your choice.

  4. Task 2 • Download IFOR.xlsx from website. • The task is to automatically state whether the pupil is eligible to enter for a particular exam if either the English or Maths scores are above 75. Hint: =IF(OR(first condition, second condition), “Yes”, “No”)

  5. Task 3 IF AND • As with Task 2, imagine using the IF AND Function to see if the pupil scores more that 55 in English and Maths , then they are entered for the exam. • Change the value of the data under maths and English to test your formula

More Related