Logical functions IF - One of the most useful features of Microsoft Excel feature is the logic functions IF.
With this feature, drawing conclusions from the available data will be easier. With a bit of learning about the formula, your business relating to the withdrawal of the data will become increasingly easy.
Here I will explain the use of the formula IF logic functions.
First of all, I would introduce a form of the formula first. The most commonly used formula is the formula in the form of:
The letter "A": the logic to be searched.
The letter "B": is the result of the calculation formula if the logic in question is true.
The letter "C" is a symbol of the calculation results when the logic in question is false.
In conclusion: If "A" is wrong, then the result is C; and if "A" is true, then the result is "B". Hopefully you understand ^_^
Using Microsoft Excel IF function for Summing Pass and Do not Pass
For more details, here I will give an example. Note the following Excel screenshot
With the IF function, we do not need to calculate the information one by one. We just need to apply logic IF formula in one column and pull it down to get the logic in the other column.
For example, with the data above, we are asked to fill in the caption with the title passed or not.
Its provisions are:
Well then, you just pull it down or do not need to write formulas one by one. The trick is to left-click the bottom right corner of the column C3 then hold and drag down until it reaches the desired column (drag and drop)
After the drop, you will get the correct calculations based on standards that you set yourself. As you can see in the screenshot above, there is a description of the "PASS" and "DO NOT PASS" because the standard value specified is 60. Therefore the value below 60 statement to be "DO NOT PASS" and otherwise.
Thus the use of logic functions IF tutorial to conclude Pass and Do not Pass students. Understanding the logic formula IF is very important and can be a plus for teachers, especially when it will enter the end of the year to determine graduation.
Good luck!
With this feature, drawing conclusions from the available data will be easier. With a bit of learning about the formula, your business relating to the withdrawal of the data will become increasingly easy.
Here I will explain the use of the formula IF logic functions.
First of all, I would introduce a form of the formula first. The most commonly used formula is the formula in the form of:
=IF(A;”B”;”C”)
Each letter in the function has a special meaning as follows:The letter "A": the logic to be searched.
The letter "B": is the result of the calculation formula if the logic in question is true.
The letter "C" is a symbol of the calculation results when the logic in question is false.
In conclusion: If "A" is wrong, then the result is C; and if "A" is true, then the result is "B". Hopefully you understand ^_^
Using Microsoft Excel IF function for Summing Pass and Do not Pass
For more details, here I will give an example. Note the following Excel screenshot
For example, with the data above, we are asked to fill in the caption with the title passed or not.
Its provisions are:
- If the average on C3 cells more than or equal to 6, then declared Passed
- and if less than 6 did not pass.
- A is the column H4;
- B is "Passed" if the value in the C3 true;
- C is "Do not pass" if the value in column C3 wrong.
=IF(C3>=60;"PASS"; "DO NOT PASS")
The formula is written in column C3 and press Enter. The formula will change into appropriate information requested by the formula. To be more clear, note the screenshot below:
Well then, you just pull it down or do not need to write formulas one by one. The trick is to left-click the bottom right corner of the column C3 then hold and drag down until it reaches the desired column (drag and drop)
After the drop, you will get the correct calculations based on standards that you set yourself. As you can see in the screenshot above, there is a description of the "PASS" and "DO NOT PASS" because the standard value specified is 60. Therefore the value below 60 statement to be "DO NOT PASS" and otherwise.
Thus the use of logic functions IF tutorial to conclude Pass and Do not Pass students. Understanding the logic formula IF is very important and can be a plus for teachers, especially when it will enter the end of the year to determine graduation.
Good luck!
0 komentar:
Posting Komentar