Im using Numbers Version 3.2 on the Mac,
I was told that you could hide the red warning triangle in the prefrence settings. But i dont see that.
What i did was create a formula in each cell and copied it. The formula works great, when there is a number in the cell to the left, but when the formula cell is empty i get the warning triangle. How could i hide the warning?
I attached a screenshot of the triangle and the formula.
the formula you are using is attempting to lookup up something and cannot finf it. The error message is telling you tat it cannot find the lookup value.
use this formula instead:
=iferror(lookup(I21, Sheet 2::Table 1::A2:A9, Sheet 2::Table 1::B2:B9 ), "")
the formula you are using is attempting to lookup up something and cannot finf it. The error message is telling you tat it cannot find the lookup value.
use this formula instead:
=iferror(lookup(I21, Sheet 2::Table 1::A2:A9, Sheet 2::Table 1::B2:B9 ), "")
I'm not sure about hiding the formula error symbol. But you can modify your formula to test for an empty cell and set the formula cell to whatever you want. For example:
if(a1 <> "", your existing formula, "")
This tests whether A1 is empty. If not it executes your formula, otherwise stores an empty string.
Hide warnings
