M
Mark
I'm using the VLookup function to source a value from one
Excel file to another. Many of the values being returned
come through as #N/A . This, in itself, is not an error,
as the file simply does not have what I'm asking for in
many instances. That's OK.
What I would like to do is put in an IF Statement that
would convert #N/A to a 0, such as the following:
=if(a1=#N/A,0,a1)
The problem is that I have not found the proper syntax for
my IF Statement that will get it to recognize the value
#N/A and convert it to the 0. My IF STATEMENT keeps
coming back with the result #N/A . Please look at the IF
STATEMENT above and tell me how I would change it to work
properl? Thanks.
Excel file to another. Many of the values being returned
come through as #N/A . This, in itself, is not an error,
as the file simply does not have what I'm asking for in
many instances. That's OK.
What I would like to do is put in an IF Statement that
would convert #N/A to a 0, such as the following:
=if(a1=#N/A,0,a1)
The problem is that I have not found the proper syntax for
my IF Statement that will get it to recognize the value
#N/A and convert it to the 0. My IF STATEMENT keeps
coming back with the result #N/A . Please look at the IF
STATEMENT above and tell me how I would change it to work
properl? Thanks.