Samudranesia.id – The functions that Microsoft Excel has are quite diverse. One of them is a logical function that makes it easier for users to process data. The logical function that is often used is the IF function or it is often called not the same as in Excel.
This function is used to perform the process of checking the data in several cells or columns. Next will be included some logic functions such as giving the status true or false. So if the data matches the criteria, certain results will appear.
Functions not the same as in Excel are very useful for various purposes, especially for making assessments. So someone does not need to do the checking process manually because from the data that has been obtained, the status can be immediately known.
The Benefits of Functions Are Not the Same as in Excel
The IF function in Microsoft Excel has quite a few benefits. Here are some benefits that are often used by data processors or ordinary users.
1. Live Data Check
One of the functions possessed by IF is to carry out the process of checking data directly. This direct data checking process can be done by doing a block process on certain tables or columns it has.
Because doing the process of checking the data directly, someone does not need to do the manual checking process one by one. Because doing the checking process one by one will be inconvenient and the chance for errors to occur is also quite high.
2. Labeling
Furthermore, functions that are not the same as in Excel can also be used to provide labels. For example at a certain value or value. If it does not meet the criteria, it can be labeled as failed. On the other hand, if it is above the criteria, it can be labeled as passed.
This labeling can be done simultaneously on all existing data. So it can be used to carry out the process of giving grades to report cards, especially for school children or college students. So the performance of the teacher or lecturer can run quickly.
3. Shorten Work
As discussed above, one of the benefits of this function is being able to provide labels and also direct checks. With this ability the performance of the teacher can be further shortened.
The most important thing is that they already have the basic formula first and then it can be directly applied. So if the results are not as desired, it will be seen clearly without having to do the checking process one by one which takes a long time.
Basic Logic of the IF Function
The logical basis of the IF function is an operator that is widely used in Mathematics. One of them is equal to or =. Furthermore, other functions or operators used consist of:
- < is used to indicate data that is not equal to or less than.
- > Used to show data that is more than or greater than the data that is used as the basis.
- <= If the data is less than or equal to what has been discussed, you can use this symbol.
- >= operator is used to indicate data that is greater than or equal to.
- = The function of this operator is to indicate if the data is the same as the logic being used.
- <> If the data is not the same as can use this operator.
IF Fungsi Function Formula
The formula for the IF or not equals function in Excel is actually quite simple. It’s just that because there is some information that must be detailed, some people find it quite inconvenient. Here’s the full basic IF function.
Formula: =IF( Logical_test; Value_If_true; value_If_False)
Information:
IF: is the name of the function in Microsoft Excel. Can be written in all capital letters or can also use lowercase letters.
Logical_test: the logical function used usually takes advantage of the greater or less than or equal to operators. Can also take advantage of a combination of these operators.
Value_If_true: the value to be shown if the logic is appropriate or true. Usually use the word pass or the like.
value_If_False: used to indicate a value that does not match the logic so that it can be labeled with another label, eg failed.
Example: IF(B2<7; "Passed"; "Not Passed")
Use of IF Function on Data
The use of this function on data can be done by creating a table first. Then you can take advantage of the steps below.
- Prepare a table that already contains the values to be tested for logic.
- Prepare a blank column on the side that will be used to enter logical functions.
- Next enter a logical function, take for example IF(B2<7; "Passed"; "Not Passed")
- Re-enter a similar logic function only by replacing the part of the cell under test. For example, it becomes IF(B3<7; "Passed"; "Not Passed")
- Next block B2 and B3, after that press the dot on the side and drag it down.
- It will automatically be applied to all data in the table.
Other Functions in Microsoft Excel
In addition to the IF function, it turns out that there are many other functions available in Microsoft Excel. Here are some that are often used by the public.
1. Sum Function
The first function that is most widely used in Microsoft Excel is the function to perform the addition process. This function can be used to add up a large number of data at one time as long as it is still in one column or 1 row.
To perform the process of summing the functions that are often used are: SUM(Range Data).
For example, we will do the summation process from cell B3 to cell B10. The formula used is SUM(B3:B10).
2. Multiplication
Furthermore, there is a multiplication function which is also used to perform the calculation process either manually or automatically. To perform the calculation process quickly, you can use the formula: =cell*cell/contact
For example, you will do the process of multiplying the data on B3 with C3. The formula that can be used is: =B3*C3. Furthermore, when doing multiplication with constants. Can use the following formula: =B3*5.
3. Sharing
Next is the division function, using the formulas in Microsoft Excel. The formula used in Microsoft Excel for this formula is to use the / operator. But still have to use the = symbol at the front.
Examples of formulas that can be used to perform the division process in Microsoft Excel are: =B3/5 or you can also divide by how many different cells: =B3/C3.
4. Average
If you want to find the average formula that can be used in Microsoft Excel, it is also quite simple. To perform an average search on cells B2 to B12, you can use this formula.
=AVERAGE(B2:B12)
The function is not the same as in Excel is one of the most widely used IF functions by the public. By using this function, the process of checking data and labeling can run automatically and quickly.
Unfortunately not everyone understands this method because it is a bit complicated and requires a high level of precision. By studying some of the methods discussed above, you can easily carry out the data checking process or be able to immediately process the data properly.
