If_empty

Summary

This video looks at if_empty; the last argument of FILTER.

Tab in example file: if_empty

If there are no values matching the filter criteria, FILTER returns the #CALC! error. To avoid this, we use the if_empty argument.

The if_empty argument can return a single value or an array (which spills into multiple cells).