Hiding an error result if error

  • Thread starter Thread starter Crusher
  • Start date Start date
C

Crusher

If I have a cell with a function and if certain information is no
present yet then it will return a N/A. I want to leave the function i
place but would not want the N/A to show but if a real result is presen
then it will show. How can I do this? (Without an If statement an
ISERROR.

Crushe
 
Hi
- select the cell (lets assume B2)
- goto 'format - Conditional format'
- enter the formula
=ISERROR(B2)
- choose a white font color
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hiding an error value, using INDEX/MATCH 3
hide the #N/A error 2
IF function using TIME 5
IF/VLOOKUP with #N/A results 6
IF statement to generate nothing 4
IsError error on Search 6
Dealing with errors 6
if statements 6

Back
Top