hiding #N/A

[Shaun]

how do i hide the #N/A function, as it is affecting my SUM

 

[John Wilson]

Shaun,

One way would be to change your formulas so that you don't
het the #N/A (it looks ugly on the worksheet anyway).

Basic format is:

=IF(ISNA(yourformula),"",yourformula)

John

 

[Naraine]

type

=if(isna(your formula),"",your formula)

 

[Tom Ogilvy]

modify your formula so it doesn't produce #N/A

=if(iserror(formula),"",formula)

 

[Perry]

Use the ISNA() worksheet function to test the outcome
of another function, like (pseudo):

=IF(ISNA(SomeOtherFunction);"";SomeOtherFunction)

Krgrds,
Perry