| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
replacing a #na
Use ISNA
=IF(ISNA(your_formula),0,your_formula) it's generally better to use ISNA in a case like this since one might want to know if there are other errors involved and ISNA only finds #N/A errors -- Regards, Peo Sjoblom "Pammy" wrote in message ... I have a vlookup and when there is nothing for it to lookup as of yet, I get a #Na, is there an =if iserror fomula I can add to the vlookup that will let me add a "0" instead of the #na? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replacing ? | Excel Worksheet Functions | |||
| Replacing #N/A | Excel Worksheet Functions | |||
| Replacing #N/A with a '0' (zero) | Excel Worksheet Functions | |||
| replacing #N/A with 0 | Excel Discussion (Misc queries) | |||
| Help Replacing all ( * ) with ( - ) | Excel Discussion (Misc queries) | |||
Threaded Mode
