problem with IF function with results from MATCH function

[michelle]

I have a cell which has done an index and a match. The
cell returns either a number or #N/A to cell G3. I
believe #N/A is an error code. However I would like to do
and IF stmt such as follows but it doesn't work.
=IF(G3="#N/A",F3,"0")

Can anyone help me around this problem?

 

[Kevin Stecyk]

Michelle,

=if(iserror(g3), f3, "0")

I am not sure you want "0" or just plain 0. Just check to be sure.

Regards,
Kevin

 

[Felipe]

Michelle,

=IF(ISNA(G3),F3,0)

Regards,
Felipe

 

[michelle]

Thanks. That works and you answered so quickly.

-----Original Message-----
Michelle,

=IF(ISNA(G3),F3,0)

Regards,
Felipe
.