IF, IFERROR FUNCTIONS

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?

• For some quit reasons, multiple IF statements require a great deal of thought to build them correctly and make sure that their logic can calculate correctly through each condition all the way to the end.
• I would say, multiple IF statements can become very difficult to maintain, especially when you come back some time later and try to figure out what you, or worse someone else, was trying to do.
• When you try to do multiple IF statements, they require multiple open and closing parentheses (), which can be difficult to manage depending on how complex your formula becomes.
• When you have a proper and clear plan on making multiple statements for combined conditions then only multiple IF statements become very easy and I reckon, IF function is very easy once you clearly understood about it syntax.

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:

• Value    Required. The argument that is checked for an error.
• Value_if_error    Required. The value to return if the formula evaluates to an error. The following error types are evaluated: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!.

 
Remarks:

• If Value or Value_if_error is an empty cell, IFERROR treats it as an empty string value ("").
• If Value is an array formula, IFERROR returns an array of results for each cell in the range specified in value. See the second example below.

 
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: