Forum Discussion

Copper Contributor

Mar 26, 2022

Solved

can I NOT display or replace with "0"if calc result "DIV/0!" so a SUM can be used on the row?

see title. thank you.

Formulas and Functions

Starrysky1988
Mar 26, 2022
You could use iferror function
=iferror(formula or calculation,0)

2 Replies

Starrysky1988
Iron Contributor
Mar 26, 2022
You could use iferror function
=iferror(formula or calculation,0)
- BunnyW
  Copper Contributor
  Apr 02, 2022
  Starrysky1988 Thank You. Thats one I never used before.

Resources