Make the #N/A invisible

[Rizana]

I have specified some formula in my Excel worksheets. But, when the
cells are empty(with no data), it shows this sign #N/A in the cells.

How could I make it invisible so that when a user print the sheet, it
will only display the cells that contain data and let the cell that contains no data(specified with formula) blank?

Any ideas?
Thanks in advanced.

 

[Aladin Akyurek]

What is the formula that returns #N/A?

BTW, apply AutoFilter that makes records with #N/A invisible before printing.

 

[onlyadrafter]

Hello,

Do you mean

=IF(isna(your_formula)),"",(your_formula))

 

[Rizana]

I used this kind of formula in the cells that returns the #N/A if there are no corresponding data for the cells :

='PCR-Master'!D43

 

[DominicB]

Good morning Rizana

If there is no corresponding data, would the formula not just return 0?
Anyway, try this :

=IF(ISERROR('PCR-Master'!D43)=TRUE,0,'PCR-Master'!D43)

This would return 0 rather than an error.

HTH

DominicB

 

[Jon Peltier]

Redundancy in formula. Use this:

=IF(ISERROR('PCR-Master'!D43),0,'PCR-Master'!D43)

 

[Rizana]

Hello everybody,

Thank you soo much for the ideas. Now, I learnt that there are many ways for me to solve the problems.

Thanks a lot.

Regards,
Rizana

 

[PaddyD]

word of caution re use of iserror() - it masks errors due to faulty formula construction, not just error returns from the data:

=IF(ISERROR('PCR-Master'43),0,'PCR-Master'!D43)

...is not an error you'd want to mask...in general, better to check directly for the source of the error if you can...