 Hi, mae gynnaeth Richard Walters, ac yn ymwneud yn ymwneud, roeddwn yn ei wneud, cystunfielwch yn cael ei gynhyrchu. Yn bod yw'n gwybod hwnna, gyda gydag i ymwneud, cyd-gwyrdd, bod yw'n gwybod cymrydau cymrydau ar y Exel, ond mae'n gwybod rwy'n gwybod at yw ymwneud. A'r cystunfielwch yn gwneud yn ymwneud, ac mae'r cystunfielwch yn cael ei gynhyrchu. Mae'r cystunfielwch yn ei gynhyrchu. demonstration, we're going to look at custom field calculations within Microsoft Project. This can be a powerful area of Microsoft Project using indicators for color coding, as well as quite complex formulas if required. So here we're going to look at using what's called a nested if node. Ifs are useful generally in Microsoft Excel, this is where the if function is generally used, but it can be used in Microsoft Project. Now we're going to look at this situation to see how the ifs can be used to control cost. So we're first going to look at the cost table, just to see what we're trying to do. So we've got different costs here for different tasks. Now what we're trying to say is if any cost is less than 2,000, so there's a couple here that's less than 2,000 down to here, then this is going to be a green indicator to say that that's that's acceptable. If anything is 2,000 up to 4,000, so 2,000 to just below 4,000, so this number here and this number here, we're going to say that that's an orange, we need to look at that cost. Anything that's 4,000 or more we're going to say that is a red color, so these numbers here. So we'll have green like a green amber red like a traffic light, so the green amber red killer controlling our costs. So let's change the table now back to our entry and we'll just stay in the entry table from now on. It's on the project tab, custom fields. In this case we want to control cost, so the type is going to be cost. We're going to rename it, we'll call it cost control, and now we're going to do a formula and yes we're going to overwrite the original field, so formula. Now we're going to use a nested if, so three ifs to do three tests. So in the first use the function if, so the general if. When I'm doing some Microsoft projects I tend to take away everything in the brackets and just start writing it bit by bit. So we want to use the field and the field is cost and we're saying if the cost is less than, so our opponent to the left, I say it's less than 2,000. Then we're going to say comma, then we'll put a number one against it, so that's going to be a number one indicator. Another comma, so move on to the next if. Now when you get used to how the if is written you can actually type it yourself. So this time I'm going to type double if and I'll take away the last bracket just to make it easy to write for now. So I'm going to write double if and every if comes with an open bracket and I do the same again, cost again and this time is less than 4,000, but greater than 2,000. Then I want that to be another comma then, that comma means then I want to target with a number two. My final test, so another comma goes in now to do another if, so and this is how you can write it in Excel as well, pretty similar. So open bracket and I'm doing another cost and this I'm going to say is greater than or equal to 4,000. We're then going to put a comma that means then we want to show what number we'll target with another three. So these one two three is what will allow us to show green orange and red and then we want to close three brackets now because we've opened up a bracket for each if. The first if has got a bracket, the second if has got a bracket, and the third if has got a bracket. So you need to close three brackets. Click OK and this is going to overwrite the field, that's fine. Now I'm going to use graphical indicators against this. I'm going to say if it equals to the number one we just put into the function, we'll say that's going to be a green because that's less than 2,000. And there's all kinds of symbols you can use. So we'll use a green. Then we'll say equals to, we'll have the orange color, if it equals three, we'll say that's a red. OK now. And let's test it. Click OK. And we'll keep in the entry table. We will just insert some fields. So I'm going to insert column and I'm going to insert the cost control. So that's a cost field. There it is. So there's the green, orange and red show against the cost. And if I wanted to see the costs against it to see how this is working, I could again insert another column or field. This time I'm going to insert the cost itself, which is here. And now I can see every green is less than 2,000. Then it goes to the yellow color. That is 2,000, so that's white yellow. And then the next yellow is over 2,000 and the same one again. Then the reds come in for anything that's 4,000 or more. And there they are. But this is the way you can use calculations in Microsoft Project, which is similar to Excel calculations. And you can use color control as has been demonstrated here with cost field. But this completes the example in this case of cost control using the nestediff to look at green, amber and red control. This now completes the demonstration on custom field calculations. See you in the next video.