IF function( ): In MS-Excel, the IF function is one of the most popular functions, and it allows you to make logical comparisons between a value and what you expect. In its simplest form, the IF function says: IF(Something is True, then do something, otherwise do something else), So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False. When you want to skip ahead to working with multiple IF statements, you can write IF functions in row conditions and working with nested formulas and avoiding pitfalls. The best way to start writing an IF statement is to think about what you are trying to accomplish. What comparison are you trying to make? Let’s me explain little bit more about IF statements, many times, writing an IF statement can be as simple as thinking through the logic in your head: “what should happen if this condition is met vs. what should happen if it’s not?” You will always want to make sure that your steps follow a logical progression, or else your formula won’t do what you think it should. This is especially important when you create complex (nested) IF statements. While Excel will allow you to nest up to 64 different IF functions, it’s not at all advisable to do so. Why?
Syntax: IF(Logical_test, [Value_IF_True], [Value_IF_False]) Q: How to find the result by testing, if average mark is greater than or equal to 65, then pass or fail in the Marksheet? Type the function as follows in the cell that you would like to get the result in: =IF(E3>=65, "PASS","FAIL") For more understanding, look at the screenshot please: IFERROR( ): I have given about the formula syntax and usage of the IFERROR function in Microsoft Excel. Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula. Use the IFERROR function to trap and handle errors in a formula. Syntax: IFERROR(value, value_if_error) The IFERROR function syntax has the following arguments:
Remarks:
Q: I have values to divide by numbers but if you wrongly typed a division value then, how to find the Error in calculation for formula? Type the function as follows in the cell that you would like to get the result in: =IFERROR((A3+B3)/C3, "Calculation Error") For more understanding, look at the screenshot please:
0 Comments
|