I have a simple calculated field
=[Total Reviews Failed]/[Total Reviews Completed]. The problem is that if these numerical columns are blank, The field returns
Can I replace the
#DIV/0! with blanks instead using an ISERROR statement?
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.Sign up to join this community
If operator (see the docs for more details). The first parameter is your conditional, the second is the value to calculate if the conditional is true, the third parameter is the value to calculate if the conditional is false.
=If([Total Reviews Completed] > 0, [Total Reviews Failed]/[Total Reviews Completed], '')