Forum Discussion

BunnyW's avatar
BunnyW
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's avatar
    Starrysky1988
    Mar 26, 2022
    You could use iferror function
    =iferror(formula or calculation,0)
Starrysky1988's avatar
Starrysky1988
Iron Contributor
Mar 26, 2022
You could use iferror function
=iferror(formula or calculation,0)
BunnyW's avatar
BunnyW
Copper Contributor
Apr 02, 2022

Starrysky1988   Thank You.  Thats one I never used before.

Resources