I ran into a circumstance where I needed the following Excel function:

```=IFERROR(value, value_if_error, value_if_no_error)
```

In other words, I'm seeking an else-clause IFERROR() method.
The problem is, you could theoretically do it like this:

```=IF(IFERROR(function(),error_value),value_if_error,value_if_no_error)
```

But what if function() could result in an error value? IFERROR() would be unable to be used since, for example, function() returns a string that may include anything, including an empty string, but also an error.

Dec 22, 2022 in Others 186 views

## 1 answer to this question.

Next to IFERROR(), there also is the ISERROR() function, which can be used as an input for an IF()-clause:

`=IF(ISERROR(value),value_if_error,value_if_no_error)`
• 63,180 points

## EXCEL-Function to find how many people does the oldest female live with

You can try something like this: =ROWS(FILTER(B11:B9291, T11:T9291=MAXIFS(T11:T9291,G11:G9291,2))) It ...READ MORE

## Excel AVERAGEIF function in combination with MOD to average over every nth row not behaving as expected

Average Every Nth Row All three finish in ...READ MORE

+1 vote

## In community edition I am unable to create tenant ,Getting this error"the filed client IP Address must be a string or array type with maximum length 64"

length is too high READ MORE

## IF - ELSE IF - ELSE Structure in Excel

If you need to test a condition, ...READ MORE

## Excel Formula - if values in columns all contain X then return

You can use the AND function: = IF(AND(A3="OK";B3="OK";C3="OK");"everything ...READ MORE

## (Excel) If cell is greater than <condition> then minus <number>

The IF function to calculate B5 (amount ...READ MORE

## IF statement for a tax sheet does not work

Use vlookup() as that is much easier ...READ MORE