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

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

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

--
Regards,
Tom Ogilvy


"Shaun" wrote in message
...
how do i hide the #N/A function, as it is affecting my SUM

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

"Shaun" wrote in message
...
how do i hide the #N/A function, as it is affecting my SUM

type

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

"Shaun" wrote in message
...
how do i hide the #N/A function, as it is affecting my SUM

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

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

Krgrds,
Perry

"Shaun" wrote in message
...
how do i hide the #N/A function, as it is affecting my SUM