=IFERROR Issue

RingJake

Hello,

I have an arithmetic formula that sometimes gives me a number, and other times does not depending on if the [Completed Milestone by Month] columns are populated.

When they are not populated they result in an error "Divide by Zero", which is fine. However I'd rather this not display on my dashboard. I've tried wrapping this in an IFERROR function, but it takes the bracket required to perform the division.

=([Completed Milestones by Month]3 - [Completed Milestones by Month]@row) / [Completed Milestones by Month]

=IFERROR([Completed Milestones by Month]3 - [Completed Milestones by Month]@row) / [Completed Milestones by Month], "-")

Paul Newcome

You need to add another opening parenthesis after the IFERROR function.