My Excel formulas used to break all the time until I found this function
I've always found it frustrating that Excel's most popular functions, such as SUM, AVERAGE, MIN, and MAX, fall apart the moment your data has a single error value. A stray #DIV/0! or #VALUE! in your range will cause the whole formula to return an error. The usual fix is wrapping everything in IFERROR, which works but clutters the formula bar.
What's Your Reaction?
Like
0
Dislike
0
Love
0
Funny
0
Angry
0
Sad
0
Wow
0
