#DIVIDE BY ZERO - Return Blank Value

mmacalvey

Hello, I have read about the IF formula, but am having difficulty applying to cells in question. I am still trying to have #DIVIDE BY ZERO return a null value when other fields are not yet populated. Any support would be greatly appreciated!

Screenshot:

https://ibb.co/g8PBn7

 

The idea is that when # of Products is blank and # of Products Published is blank, that % of Products Completed would appear blank as well. Once a value is input into # of products and # of Products published, it is then that % of Products Completed would divide and appear with % value.

Chris McKay

Hi mmacalvey,

IFERROR is your friend :-) If you wrap your IF statements in IFERROR, you can specify a text value (in this case a double quote "") to return a blank value for the cells in question.

 

mmacalvey

Thanks for the reply, Chris!

Chris McKay

My pleasure!