Excel has hundreds of options designed for a multitude of different tasks, many of them can be used in simple way by users, while others are a bit more complicated. One of these is the Yes function. So the if function in Excel what is it? What is it for? and How is it used?
We will answer all the previous questions in this space, if you have doubts about the Very useful If function in Excel, This is the right place. Here we will clarify the basic principles that you must know to master this useful tool.
IF function in Excel
The Si Function of Excel It is one of the best known of the hundreds of options that this Microsoft program allows us to use. Even so, it is also one of the functions that generate more doubts in novice users.
We will solve these doubts today. On the other hand, it is important to note that we also recommend learning how to use Excel’s add function, another essential tool when starting out in this office automation program.
What is the If function in Excel?
The If function is a function of the logical type present in Microsoft’s Excel program. In short, we could determine that this function will show us a result in relation to the exposed data, a result that we define as True or false.
One of the most interesting points of this function is that it allows us in a very simple show if a data present in a work table meets the conditions to show one or another factor.
If you still have doubts in relation to this type of functions, we recommend that you read this information about what they are and how to do logical functions in Excel, a guide that quite possibly guides you in the best way in relation to this office resource.
What is the If function in Excel for?
In its simplicity, this interesting function can be used in a multitude of different circumstances. Being suitable for company administrators, teachers and even for those users who want to carry a expense control.
To explain the value of this great function of Excel, it is best to come up with some situations where it could be very useful.
Usefulness of the SI function for teachers
The function Yes It is one of the favorites of teachers, since it allows in a very simple way to show whether a student is approved or disapproved, whether or not they turned in an assignment, among other useful options for teaching.
Also in relation to this utility, it is convenient to know how to get the total and subtotal in Excel, a utility that will not only be useful for teaching but also for any job that requires making calculations quickly.
How do you use the If function in Excel?
The way to use the tool is very simple, you just have to be very clear about what you want to do with the function. In this case, suppose we want to set the condition of approved or disapproved, something a teacher would use constantly.
- First of all, you must have a functional table, so this tutorial is designed for those who want to improve the interface of their workspaces. Don’t worry, if you are a newbie, you can visit our website to find the best tutorials.
- Well, having our table of notes, we will proceed to use the If function. To do this, select a place in the table where you want the answer to be reflected Approved or Reprobate.
- Being in that line go to Formulas or Insert function and look for the option YES, click on that function. Where three options will appear Logical_test, Value_if_true and Value_if_false.
- In Logical Test is where the formula to be used will be. In our case, you just have to click on the table where the student’s total grade is, it will then be reflected in Logic Test.
- Assuming that the grades are weighted from 1 to 10, where 5 is approved, we must do the following: Having indicated the total grade line, located for example in D3, the formula should be as follows D3 <5.
- Value if true, in this place we will set the value if the previous formula is true. In our case it would be ReprobateIn this way we will determine that any value less than 5 will be classified as Failed.
- In Value if false, just put Approved, this means that any value equal to or greater than 5 will be determined as Pass.
In general terms this is the way to work with the function Yes. It does not necessarily have to be a function to determine if a student was failed, in fact, you can use it for all kinds of functions, for example to establish that a result is unsatisfactory and does not meet (or does) what is required.
The Si function can be tricky for newbies, but it is undeniably very useful. In any case, if there are logical problems, it is highly recommended to use the SI.ND and ESNOD function and find out if a cell has a value error, determining a formula in the most correct way possible.