Hide error signs when using stocks

I’m making a spreadsheet for my stocks and is using them to track dividends. Some stocks don’t have any so it displays an error. Is there any way to make it display a zero instead of a error triangle?

MacBook Air 13", macOS 10.15

Posted on May 9, 2020 6:14 PM

Top-ranking reply

Barry

Level 9

60,023 points

Posted on May 9, 2020 6:47 PM

Wrap your current formula is IFERROR.

IFERROR(formula,0)

Note that this will trap ALL error messages, j=not just the ones caused by lack of a dividend value.

Regards,

Barry

View in context

Similar questions

Numbers warnings Hi, I have modified a spreadsheet which previously had no blue corner flags and no red warning triangles. Because of the new calculations I have added, the sheet is covered with both of them. The problem seems to be to do with comparing numbers with strings. Nevertheless, when I fill in the sheet with dummy numbers, all the calcs work and the blue and red warnings disappear. If these warnings are only there to say ’things aren’t as we expect but we can and will do the calculation anyway’, is there a magic button somewhere that will suppress all these annoying warnings ?
509 5

1 reply

Top-ranking reply

Barry

Level 9

60,023 points

May 9, 2020 6:47 PM in response to RepeatRHH

Wrap your current formula is IFERROR.

IFERROR(formula,0)

Note that this will trap ALL error messages, j=not just the ones caused by lack of a dividend value.

Regards,

Barry

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Hide error signs when using stocks