return a blank when #divide by zero

Si Spence

friends,  is there a quick n easy way to return a blank in a cell instead of #divide by zero

pls see screenshot.    ta,  Si.

Shaine Greenwood

Wrap your formulas in an IFERROR function: https://help.smartsheet.com/function/iferror

You can set the value_if_error to "" which will return blank.

Si Spence

Thanks Shaine,  It's easy when you know how!