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,010 points
186 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,180 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 in Others by narikkadan
• 63,180 points
326 views
0 votes
1 answer
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,220 points
911 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,180 points
916 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,180 points
534 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,180 points
186 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 in Others by narikkadan
• 63,180 points
173 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,180 points
1,682 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,180 points
413 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