How to hide #DIVIDE BY ZERO error message

Stephanie_A_W

Hello,

I am looking for help utilizing a formula to hide the #DIVIDE BY ZERO error message.

My current formula in the "Change" column is simple:

=([Availability %]@row - [Previous Availability %]@row) / [Previous Availability %]@row

But for any cells in the "Previous Availability %" column that have 0%, I get the #DIVIDE BY ZERO error and I'd like that to be hidden.

Thank you,

Stephanie

Marlana K.

Hi @Stephanie_A_W Use IFERROR and , " " for the value if false this will leave it blank.

=IFERROR([Availability %]@row - [Previous Availability %]@row) / [Previous Availability %]@row, " ")

see the difference in mine when using If error

Stephanie_A_W

Hi Marlana,

This worked. Thank you!!

Marlana K.

Hi Stephanie!

Happy to have helped.