Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dealing with #N/A results
Is there a way to replace all the #N/A results from any formula? If you try
to use #N/A in the replace function, Excel doesn't recognize it. The only work around I could come up with is to sort the column with the #N/A's and then delete or copy over them. Thanks, Sandy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dealing with #N/A results
Wrap your formula in an error handler such as:
if(isna(your formula),0,your formula) in simple terms, if your formula returns the #N/A error return a zero (you could use "" instead and leave the cell blank if you prefer). If it returns a valid value return that value. I use this method to trap errors in vlookups (I use iserror because it traps all errors) e.g. =if(iserror(vlookup(A1,$B:$C,2,0)),0,vlookup(A1,$B :$C,2,0)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to pick Home and Away results from a list | Excel Worksheet Functions | |||
Paste results consecutively within column (based off other worksheet) | Excel Worksheet Functions | |||
abdualmohsn | Excel Discussion (Misc queries) | |||
Date stamp formula results? Tricky problem? | Excel Discussion (Misc queries) | |||
calculating results in formulas | Excel Discussion (Misc queries) |