#DIVED BY ZERO

Nemo · 02/15/19

I am trying to get this to just show a zero when it occurs. This is the formula I am trying to use, can anyone assist?

=SUM([2019 DART]3 * 200000 / [2019 Hours]3)=IFERROR [2019 DART Rate],"0")

Mike Wilday · 02/15/19

Try wrapping your formula with the IFerror.

=IFERROR(SUM([2019 DART]3 * 200000 / [2019 Hours]3), 0)

Mike Wilday · 02/15/19

Here is an article specifically on how IFERROR is to be used: https://help.smartsheet.com/function/iferror

Nemo · 02/15/19

Thank you! That fixed me.

Mike Wilday · 02/15/19

Awesome. Glad it worked for you. Have a great day.

Comments