MS Excel cell reference hiding function?
I need a formula to hide this function in a cell, when there is no value (”#REF!, #N/A”).But I want result to appear for those reference, if there is a numeric or text value.
I need a formula to hide this function in a cell, when there is no value (”#REF!, #N/A”).But I want result to appear for those reference, if there is a numeric or text value.
sarvy
Favorite Answer
To hide error value in cell, use "ISERROR" function
to hide #REF!,#N/A
Example: =IF(ISERROR(LOOKUP(A10,B14,C15)),"",
LOOKUP(A10,B14,C15))
Don R
It sounds like there is already a formula in the cell that displays these ERROR types. The reason they occur is that the formula cannot act on the data in the cell that the formula is working on. In other words, your can't divide text and come up with a number so it gives an ERROR. I think you will have to fix the formula so as not to do that. You should also look at the function called ERROR, TYPE. You might be able to usit along with IF.
Altid Jeg Elsker Dig
i don't understand if you want to hide the contents of a cell? i do think you can do it.. but if you want to hide a row or column you can do it by right clicking on selected object and select the hide option
merlot7799
If you're trying to do what I think you're trying to do, you can't do it. What is the formula you're using to get those results?