SOLVED

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

Copper Contributor
2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution
You could use iferror function
=iferror(formula or calculation,0)

@Starrysky1988   Thank You.  Thats one I never used before.

1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution
You could use iferror function
=iferror(formula or calculation,0)

View solution in original post