 Rwy'n gwneud y ffówrdd hynny ymlaen nhw'n gwybod y ffówrdd ffuncton ar gwybod ymweld yng Nghymru yn Microsoft Extile. Rwy'n gwybod dwyloedd cyfnodol yn ymddugol. Rydw i'n gwybod cyhoedd Cymru. Rydw i'n gwybod ymlaen yw'n gwybod Ymddugol a'n gwybod ymlaen yw rowan. Rydw i'n gwybod ymlaen yw, dyma'r ffordd yw'r ffordd. If someone works in the administration department, they're going to go on and do a project. So anyone who works in the administration is going to do a project. So the function is perfect for this kind of analysis. So I'll start off by typing in equals, then if I can double left click and FX it. When you're learning, it's good to use these boxes as you get better. You can start writing them in a formula bar. So for this example, I'll just keep on using the box at the time for these examples. So the logical test is the first department, which happens to be D6. I'm asking the question is D6 equal to, and I'm looking for administration. So it has to be typed in double inverted commas, administration, and then closing inverted commas. The word false comes up because D6 equals sales. If it was administration, it would say true. So then I go into the area if true, what I want to see, I want to see the word project. That's going to be in double inverted commas. And if it's false, I want to see the word, I want to see just blank, leave it blank. So the formula result is blank, and that's because D6 is not administration. So wherever it finds administration, we'll see the word project, which is what we've told it to do if the value is true, and if the cell is administration. Click OK. Blank is no problem because we're expecting that. You can double click the copy down, and now we can see every administration department is doing a project. If I go into the next example, we're looking for salaries, which are less than or equal to 40,000. So if again, and I can double click, use the if. This time I'm looking at salaries. First cell is E6, and we're asking a question. Is it less than, so it's arrow to the left, or equal to, then an equal sign. And we're asking, is it less than equal to 40,000? So just a pure data entry. If it's true, we're going to say the, this, we'll say salary is less than 40,000. So in invidio commas, salary is than 40,000. Otherwise, a little bit blank, I'll just sort out the type in there. A little bit blank otherwise. So we've got the answer for the first one, salary is less than 40,000. And that's because 35,000 is less than 40,000. So when it comes to the 40,000 here, it should include it. Because we've said less than or equal to 40,000. Click OK. Widen it a bit to get the text in. Double click. And we can see all the salaries which are less than or equal to 40,000. And there's the one that is equal to 40,000. So we can see how it's working. Next example, salary is greater than or equal to 55,000. We're going to show the actual salary. So equals if again. And we're testing the salary, which is E6. And we're asking the question, is it greater than, so are to the right or equal to 55,000. False is the result because the first salary is not greater than or equal to 55,000. It happens to be 35,000. If the value is true, we want to show the actual value this time. So what we do for that is just click on the, in the salary cell. So that happens to be the first one happens to be E6. Otherwise, leave it blank. So blank is the answer for the first one because it's not greater than or equal to 55,000. That's why it's blank. OK, double click. And now we can see all the salaries, which happened to be 55,000 or greater. And there's the one that actually equals 55,000. So we can see how it's working. The last example of if analysis and the basics of an if in this video, we're going to look at any salary which is less than or equal to 35,000 to give them a 10% salary increase. So a little bit of calculation. So equals if again. And we're testing salary. We're asking a question, is it less than or equal to 35,000, which the first one is. So that's why it says true. If that's the case, we want to increase the salary by 10%. So it's going to be the salary, which then the first salary is in E6. So E6 multiplied by 1.10. So the 1 represents 100%. 0.10 means it's a 10% increase. So we're going to increase it by 10%. So it's gone up to 38,500. Well, if we look at the salary, it's 35,000. What's 10% of that? 35,000 plus 35,000 will give us the mental maths of 38,500. So the maths behind this is correct. Otherwise, we're going to say lead it blank. So it shows the answer 38,500 for the first one, because that happens to be less than or equal to 35,000. Click OK. Copy it down. And all the salaries now, whichever happened to be less than or equal to 35,000, have been increased by 10%. So this now gives an example in this video of how the IF function in its basic format can be used for analysis purposes, whereby we've gone through if a department is equal to administration, put them on project. If the salary is less than or equal to 40,000, show the text, the salary is less than or equal to 40,000. If the salary is greater than or equal to 55,000, display the salary, which we've now done. And the last one gives us a 10% increase in salary. If the salary is less than or equal to 35,000. So in this example, we've seen four pretty basic examples of the use of IF and how IF can be used for analysis purposes. And this completes this training video on the basics of the IF and how it can be used for analysis purposes.