How to removed #DIVIDE BY ZERO — Smartsheet Community


Hi @pmolloy,

Add an IFERROR round your current formula.

For example, if you want the cells that currently have the error to be blank instead:

=IFERROR([Margin $]@row / [Forecast Amount $]@row, “”)

If you want another outcome, amend the final “” portion.

Hope this helps, but if you’ve any problems/questions then just ask.



Source link

Leave a Comment