Is there a way to do if error formulas or just if statements get around divide by zero errors in custom formulas? I tried =IF(A1=0,0,B1/A1). I get a value calculating, but I still get #DIV/0! and #VALUE! errors.
The only workaround I’ve come across is nesting redundant if formulas to check and avoid divide by zero errors. I’m not sure if this has been improved upon recently, but would be nice if there was native support for iferror.
Check out this post from a couple years ago for more info. The workaround proposed by Jon has been working for us:
“Safe division” in custom formulas is on the roadmap and coming soon.