Calculation only if the field is not blank

Barbara Witt

I would like to conduct a simple division calculation, but only if the fields are not blank or if there is data in the fields. Because if there is no data in the field, then the division comes back as "#Divide by Zero". How can I avoid that?

=([# of Ambient device installed]@row * 100) / [# of Ambient device scoped]@row

Thanks so much for your assistance.

Best regards, Barbara

Stefan

Hi @Barbara Witt,

you may use IFERROR

https://help.smartsheet.com/function/iferror

or you may use the IF function to check if a cell is empty or has a certain type of content.

Hope this helps

Stefan

Stefan

Hi @Barbara Witt,

you may use IFERROR

https://help.smartsheet.com/function/iferror

or you may use the IF function to check if a cell is empty or has a certain type of content.

Hope this helps

Stefan

Barbara Witt

I very much appreciate your assistance. This worked perfectly. Best regards and Happy Valentine's Day.