VBA If formula

[gt213]

I have the following code to see if 2 cells are equal to each other.

If ws5.Cells(rw.Row, 2) = ws5.Cells(rw.Row, 3) Then
ws5.Cells(rw.Row, 5) = 1
Else
ws5.Cells(rw.Row, 5) = 0

The issue i'm having is that if one of the cells contains #N/A it is returning 1 instead of 0 which is what i want it to do.

Is there a way around this?

 

[Joe4]

Check to see if either is #N/A first.
Here is a link that shows you how to do that: https://www.mrexcel.com/forum/excel-questions/758040-vba-if-cell-contains-n-then.html

 

[louisH]

Hi,

If ws5.Cells(rw.Row, 2) <> ws5.Cells(rw.Row, 3) Or IsError(ws5.Cells(rw.Row, 2)) Or IsError(ws5.Cells(rw.Row, 3)) Then
    ws5.Cells(rw.Row, 5) = 0
Else
    ws5.Cells(rw.Row, 5) = 1
End If

Hope it helps

 

[gt213]

Thanks both of you - i used the above any got it to work