IF Error Function help

roya

Hello, Request your help to figure out what I may be doing wrong here. Please see the screen shot below

The formula is on the % complete column below. I want the #DIVIDE BY ZERO to be a NULL value and was trying to use the formula below .

The formula gets the desired result but I want the I want the #DIVIDE BY ZERO to be a NULL

=IFERROR([Count Checked]@row / Total@row * 100 + "%"), " ")

Corey W.

You just have a missing parenthesis. Try:

=IFERROR(([Count Checked]@row / Total@row * 100 + "%"), " ")

Corey W.

You just have a missing parenthesis. Try:

=IFERROR(([Count Checked]@row / Total@row * 100 + "%"), " ")

roya

Thank you so much!!! Corey!!!

This worked!!! I really appreciate your help.