Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
hiding #N/A
how do i hide the #N/A function, as it is affecting my SUM
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
hiding #N/A
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
hiding #N/A
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
hiding #N/A
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
hiding #N/A
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hiding zero for a sum | Excel Discussion (Misc queries) | |||
hiding | Excel Discussion (Misc queries) | |||
Hiding a button when hiding rows | Excel Discussion (Misc queries) | |||
#DIV/0! hiding | Excel Discussion (Misc queries) | |||
Hiding #N/A | Excel Worksheet Functions |