# Add Percentage to divide by 0 error in formula column

I am trying to calculate the accuracy rate (%) using {# of corrected work} devide {# of reviewed work}

With an old thread I found a formula in the forum that can resolve the error in result. However, if I changed the formula, the error pops up again in the accuracy column.

2(# of corrected) / 10 (# of reviewed) = 0.2 (accuracy rate)
I need the result to be 20% instead of 0.2%

I am hoping someone can help or shed some lights here! Many thanks.

Here’s the formula I found posted by Jim Correll
The first, make all parts of a formula always work:

IF(AND({column1}<>0,{column2}<>0),{column1}/IF({column2}<>0,{column2},1),“”)

Second, use the DIVIDE function instead of the operation:

IF(AND({column1}<>0,{column2}<>0),DIVIDE({column1},{column2}),“”)

@Raeeee

Percent by definition is parts in 100. So, often, depending on context to the proper representation, you must multiply the result by 100 to show the value correctly.

Thanks for your reply. I used below formula to show the value. However, if the data is “0”, it shows error.
IF({Reviewed (#)}=0,0,IF({Processed (#)}=0,0,((1-DIVIDE({Revised (#)},{Reviewed (#)}))*100)))

Any ideas of how to make “0=blank” after multiple 100? Thank you so much for your help.

@Raeeee

I do not understand what you mean by “Any ideas of how to make “0=blank” after multiple 100?”

It is unclear why the DIVIDE() is not working here.

Try this:

``````IF(AND({Reviewed (#)} > 0, {Processed (#)} > 0),
((1 - ({Revised (#)} / IF({Reviewed (#)} > 0,
{Reviewed (#)}, 1))) * 100)
, 0)
``````

1 Like

OMG. It works! This is exactly what I was looking for. You are definitely a rockstar. 1 Like