Make the #N/A invisible

R

rixanna

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 I could make it invisible so that when a user print the sheet, it
will only display the cells that contain data?
 
P

Pete_UK

Another way is to amend your formulae so they don't produce the errors:

=IF(ISNA(your_formula),"",your_formula)

Hope this helps.

Pete
 
A

aaron.kempf

I know how to get rid of N/A...

don't use Excel.
don't use Excel.
don't use Excel.

how is that for a solution?

use MS Access or something similiar.. Access Data Projects _ROCK_

-Aaron
 
Top