Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
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.
4 Answers
- sarvyLv 41 decade agoFavorite 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 RLv 51 decade ago
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.
- 1 decade ago
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
- 1 decade ago
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?
