Forum Discussion
Hide error strings
Hi, I am trying to hide error string messages in a formula cell when it calls on data from a cell that is blank. The formula needs data from 2 cells and when I fill in 1 of the cells, the error messages are shown until the data is entered into the other cell. Is there a way to hide these strings?
11 Replies
The simple answer is "Yes"
In fact, there are probably several ways to do it. Can you upload your actual file (or a sample of it) so that I or someone else can give a specific recommendation?
In the absence of that, let me recommend that you research functions like IFERROR or IFNA as potential solutions. You might be able to resolve this totally on your own through one of those.
JoeRock There is no error! You formula in C5 merely returns a value of -$177,775,00. The column width is simple not large enough the display that number. See below.
