Automatically finish IFERROR() with ""
The second argument of IFERROR() is currently required, but it should be optional and the default would be to replace the error with ""). There are exceptions of course, but I think the majority of users put in IFERROR() to get rid of ugly errors that they're expecting, like in a series that will be completed in the future.
I find myself retroactively adding IFERROR( to the beginning of my formulas to clean up the worksheet, but Excel requires me to also click to the end of the formula and add the second argument plus an ending parentheses. For how often I do this, it should be as simple as adding IFERROR( to the beginning and hit enter.
On a related note, I happen to think Excel should automatically fill in the end parentheses of a lot of functions instead of hitting me with a warning dialogue. I just can't think of the rules for how to regulate that right now.
Sergei Baklan commented
It depends on situation, but usually I prefer to return zero, not empty string. And it almost default value, IFERROR(value,) returns 0.
As well as some other, e.g. IF(1,) returns zero.
Better to have here NULL (or BLANK, whatever) if it'll be implemented one day.
Excel Help commented
Kenneth I bring it up because this, like so many other intuitive and time-saving features, is a native feature in Google sheets. I'm sure you've either seen in these forums or experienced yourself that Google is much more attentive to user input and more aware of how we use their products than MS is, and the fact that this autocomplete already existed there before I even knew I needed it is a testament to how many people would use it in Excel.
Kenneth Barber commented
I should also mention that you could write a small macro to do the IFERROR wrapping if you don't like the manual approach.
Kenneth Barber commented
I understand that you are trying to make a common task easier (of yours), but I don't think that it is worth changing Excel (for everyone) to do it. The way that you are using IFERROR is more specific to you than you think.
In addition to "", IFERROR is also commonly used with 0 as the second argument, usually when you are handling divisions by 0 or using the result in further calculations.
I disagree with your suggestion about automatically adding ,"") at the end of a formula when you put IFERROR( at the start of your formula. What about when you write IFERROR in the middle of an existing formula? What if you intended your IFERROR to wrap around only part of your formula and not the entire thing?
Instead of retroactively writing IFERROR, why not just write it when you first write your formula?
Lastly, if you know what range of cells will need the IFERROR wrapper, and none of these cells use the = sign other than to start the formula, you can select those cells, replace all = with t= (any letter before = should do) to convert the formulas to text to avoid a parenthesis mismatch error for what we are about to do next. Then replace all = with =IFERROR(. Then fill in the ,"") manually. When you are done, replace t= with = to convert the text back to formulas.