| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula returns #N/A
I have a formula which returns #N/A in some cells in a string--I need a
formula to ignore the error and leave the cell blank so that another formula which reads the contents of that cell will skip over it and go to the next cell |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formula returns #N/A
The most common method:
=IF(ISNA(your_formula),"",your_formula) HTH Jason Atlanta, GA -----Original Message----- I have a formula which returns #N/A in some cells in a string--I need a formula to ignore the error and leave the cell blank so that another formula which reads the contents of that cell will skip over it and go to the next cell . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
formula returns #N/A
Thanks very much--I have been looking for a solution for a while now and
this works like a charm--best regards!!!! Kyler "Jason Morin" wrote: The most common method: =IF(ISNA(your_formula),"",your_formula) HTH Jason Atlanta, GA -----Original Message----- I have a formula which returns #N/A in some cells in a string--I need a formula to ignore the error and leave the cell blank so that another formula which reads the contents of that cell will skip over it and go to the next cell . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula returns #N/A | Excel Discussion (Misc queries) | |||
| IF formula returns error; abbreviating the formula | Excel Discussion (Misc queries) | |||
| Index with mulitple value returns and muliple column returns | Excel Worksheet Functions | |||
| Formula returns a zero | New Users to Excel | |||
| Formula Returns #N/A | Excel Programming | |||
Linear Mode
