00:00Have you ever had to repeat a function call because you need it several times in your formula?
00:04Let me show you what I mean by that. I have a data set of student results here. I want
00:08to count
00:08the number of subjects each student passed with a grade of over 50. If the count is more than
00:13two subjects, I'll show the count. But if it's less than two, I'll show not met. As you can see
00:19in my formula, the counted function is called twice here like this. This method of writing a
00:24formula can introduce error and managing the formula can be tough. Let me show you how I can
00:28use a let function. I'm going to hit enter here and basically copy the count if. You're
00:33going to start with let. The first argument, I'm going to say variable a is assigned to
00:37that count if itself, comma. And now I'm going to do the if statement here, open parenthesis.
00:43Now, since a has a value of count, it's going to say a greater than two. You're going to show
00:47the value of a, which is the count. And then if it's not true, I'm going to say not met
00:52like this. And two parenthesis hit enter. It produces the same result as the formula before.
00:58you're going to declare experience. And that is a pretty good answer. And I think we've
00:58are going to give you might have to bequalified, that's a little that is a very good answer.
00:58But then, if you keep going, let's try it online. Amen.
00:59Now know how much you can get to see here, some reason is what I've been sort of pain.
Comments