IfError with else does this function exist in Excel

0 votes

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 by Kithuzzz
• 38,000 points
846 views

1 answer to this question.

0 votes

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)
answered Dec 23, 2022 by narikkadan
• 63,600 points

Related Questions In Others

0 votes
1 answer

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

answered Jan 13, 2023 in Others by narikkadan
• 63,600 points
618 views
0 votes
1 answer

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

answered Mar 27, 2023 in Others by narikkadan
• 63,600 points
391 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

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

answered Feb 17, 2022 in Others by gaurav
• 23,260 points
1,336 views
0 votes
1 answer

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

answered Nov 4, 2022 in Others by narikkadan
• 63,600 points
1,564 views
0 votes
1 answer

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

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

answered Nov 7, 2022 in Others by narikkadan
• 63,600 points
1,427 views
0 votes
1 answer

Multiple IF statements in Excel not working

When you add an IF statement to a formula ...READ MORE

answered Nov 12, 2022 in Mobile Development by narikkadan
• 63,600 points
526 views
0 votes
1 answer

IF statement for a tax sheet does not work

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

answered Mar 20, 2023 in Others by narikkadan
• 63,600 points
523 views
0 votes
1 answer

IF function in combination with an Round function Excel

I'm not sure if it is a ...READ MORE

answered Sep 25, 2022 in Others by narikkadan
• 63,600 points
3,535 views
0 votes
1 answer

Excel trim function is removing spaces in middle of text - this was unexpected (?)

Create a UDF that uses VBA's version ...READ MORE

answered Oct 18, 2022 in Others by narikkadan
• 63,600 points
865 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP