Hiding an error result if error

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
 
F

Frank Kabel

Hi
- select the cell (lets assume B2)
- goto 'format - Conditional format'
- enter the formula
=ISERROR(B2)
- choose a white font color
 
Top