Question

Suppose =IFERROR(5000/2,1000)+100 is entered into a cell. What is the resulting output of this formula?

Answer 1

Answer:

The answer will be 2600

Explanation:

Answer 2

Answer:

The output of the given formula is #VALUE!

Explanation:

#VALUE!  :

• This appears in the excel sheet when there is any wrong in the formula that you have typed of there is something wrong in the reference cell.

The #VALUE! error occurs in the excel due to the following cases:

1. Summing text and numerical value together
2. Summing text values
3. Multiplying numbers with text or blank cells
4. Summing and multiplying ranges
5. Providing a text value to the NETWORKDAYS function
6. Creating an illogical IF formula

IFERROR:

• Under Excel logical functions category The IFERROR function is found.
• ISERR, ISERROR, IFERROR and ISNA are the error checking function in which IFERROR belongs to.
• When we deal with formulae and data we may get error. #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME? or #NULL! are used to handle errors.

Formula : =IFERROR(value,value_if_error)

• value = The value which we have to test
• value_if_error = If the formula was evaluated to an error the value will be returned.

Input:

= IFERROR(5000/2,1000)+100

Output:

#VALUE!

#SPJ2