0

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 #DIV/0!.

Can I replace the #DIV/0! with blanks instead using an ISERROR statement?

0

Use the 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.

For example: =If([Total Reviews Completed] > 0, [Total Reviews Failed]/[Total Reviews Completed], '')

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.