problem with IF function with results from MATCH function

  • Thread starter Thread starter michelle
  • Start date Start date
M

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?
 
Michelle,

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

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

Regards,
Kevin
 
Back
Top