| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Change #N/A to a number
I have a column in excel that either contains numbers or #N/A. These values
where derived from a vlookup. For all the cells that have #N/A I want a zero to be put in that cell. I need a function or procedure to do this to add to my visual basic code in my excel macro. Basically, how do I change the #N/A to a 0? Thanks! |
|
#2
|
|||
|
|||
|
=IF(ISNA(your_vlookup_formula),0,your_vlookup_form ula)
-- Regards, Dave "85225" wrote: I have a column in excel that either contains numbers or #N/A. These values where derived from a vlookup. For all the cells that have #N/A I want a zero to be put in that cell. I need a function or procedure to do this to add to my visual basic code in my excel macro. Basically, how do I change the #N/A to a 0? Thanks! |
|
#3
|
|||
|
|||
|
Thanks,
It worked! "David Billigmeier" wrote: =IF(ISNA(your_vlookup_formula),0,your_vlookup_form ula) -- Regards, Dave "85225" wrote: I have a column in excel that either contains numbers or #N/A. These values where derived from a vlookup. For all the cells that have #N/A I want a zero to be put in that cell. I need a function or procedure to do this to add to my visual basic code in my excel macro. Basically, how do I change the #N/A to a 0? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change color of cell after user has input a number | Excel Discussion (Misc queries) | |||
| How do I change the number on copy sheet so I don't have to renam | Excel Worksheet Functions | |||
| How do I change a text fraction. eg 1 1/2 into a decimal number, . | Excel Worksheet Functions | |||
| How do you change the date to a Number | Excel Discussion (Misc queries) | |||
| EZ Q 4 U: How do I change a number to text, based on the number | Excel Worksheet Functions | |||
Linear Mode
