Divide By Zero Error

Craig Beattie

Hi all,

As you can see I have done a sheet that calculates % of each quarter.

Is there a way if blank for one of the quarters that it will not return Divide by Zero error?

Andrée Starå

Hi @Craig Beattie

I hope you're well and safe!

Try something like this.

=IFERROR(YOUR-CURRENT-FORMULA, "")

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Craig Beattie

I hope you're well and safe!

Try something like this.

=IFERROR(YOUR-CURRENT-FORMULA, "")

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Craig Beattie

Hi @Andrée Starå

All good here hope your well.

That worked perfectly, thank you again for your help.

Have a good weekend.

Andrée Starå

@Craig Beattie

Excellent!

Glad to hear all is good, and it's the same here.

You're more than welcome!