S
Shaun
how do i hide the #N/A function, as it is affecting my SUM
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
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
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
N
Naraine
type
=if(isna(your formula),"",your formula)
=if(isna(your formula),"",your formula)
T
Tom Ogilvy
modify your formula so it doesn't produce #N/A
=if(iserror(formula),"",formula)
=if(iserror(formula),"",formula)
P
Perry
Use the ISNA() worksheet function to test the outcome
of another function, like (pseudo):
=IF(ISNA(SomeOtherFunction);"";SomeOtherFunction)
Krgrds,
Perry
of another function, like (pseudo):
=IF(ISNA(SomeOtherFunction);"";SomeOtherFunction)
Krgrds,
Perry