Stupid If statement question....
 

I have a vlookup in one column that has results = #N/A

I need to do an if statement, that looks like:
If the field =#N/A, then 0, if not, the field.
Basically, I want to convert all of the #N/A's to a 0 (zero) in another
column....

Stupid If statement question....
 

You could copy and paste the results as values, then highlight the column and
'edit ' , 'replace' , find what = #N/A , replace with = 0

"Send Object Command - Two attachments" wrote:

I have a vlookup in one column that has results = #N/A

I need to do an if statement, that looks like:
If the field =#N/A, then 0, if not, the field.
Basically, I want to convert all of the #N/A's to a 0 (zero) in another
column....

Stupid If statement question....
 

I know I can that....however, I need to have this in a formula.
I need this done automatically.

Any other suggestions?

Thanks -

"PhilinLondon" wrote:

You could copy and paste the results as values, then highlight the column and
'edit ' , 'replace' , find what = #N/A , replace with = 0

"Send Object Command - Two attachments" wrote:

I have a vlookup in one column that has results = #N/A

I need to do an if statement, that looks like:
If the field =#N/A, then 0, if not, the field.
Basically, I want to convert all of the #N/A's to a 0 (zero) in another
column....

Stupid If statement question....
 

=IF(ISNA(VLOOKUP([your vlookup]),0,VLOOKUP([your vlookup]))

Dave
--
Brevity is the soul of wit.


"Send Object Command - Two attachments" wrote:

I know I can that....however, I need to have this in a formula.
I need this done automatically.

Any other suggestions?

Thanks -

"PhilinLondon" wrote:

You could copy and paste the results as values, then highlight the column and
'edit ' , 'replace' , find what = #N/A , replace with = 0

"Send Object Command - Two attachments" wrote:

I have a vlookup in one column that has results = #N/A

I need to do an if statement, that looks like:
If the field =#N/A, then 0, if not, the field.
Basically, I want to convert all of the #N/A's to a 0 (zero) in another
column....

Stupid If statement question....
 

=IF(ISNA(formula),0,formula)

replace formula with your formula, or the cell in question. you can also
use the following formula to account for any other type of error (#DIV/0 for
example).

=IF(ISERROR(formula),0,formula)


"Send Object Command - Two attachments" wrote:

I have a vlookup in one column that has results = #N/A

I need to do an if statement, that looks like:
If the field =#N/A, then 0, if not, the field.
Basically, I want to convert all of the #N/A's to a 0 (zero) in another
column....

Stupid If statement question....
 

I have ssumed that you have a formula that either gives a value or #N/A

To do what you want you need to refer to the error, not the result

=IF(ISERROR(cell ref),0,1)

If the cell you are pointing to results in an error (eg #N/A) then it
will give a value of 0, if no error found then it will give a value of
1

Hope this helps

Steve

Stupid If statement question....
 

Worked like a charm - thansk to all.

"Sloth" wrote:

=IF(ISNA(formula),0,formula)

replace formula with your formula, or the cell in question. you can also
use the following formula to account for any other type of error (#DIV/0 for
example).

=IF(ISERROR(formula),0,formula)


"Send Object Command - Two attachments" wrote:

I have a vlookup in one column that has results = #N/A

I need to do an if statement, that looks like:
If the field =#N/A, then 0, if not, the field.
Basically, I want to convert all of the #N/A's to a 0 (zero) in another
column....