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
• 28,700 points
51 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
• 53,160 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
• 53,160 points
45 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
• 22,940 points
125 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17, 2022 in Others by Edureka
• 13,630 points
175 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
• 53,160 points
95 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
• 53,160 points
89 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
• 53,160 points
52 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,630 points
213 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
• 53,160 points
130 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
• 53,160 points
88 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