Iserror returns "FALSE" but acts like it was "TRUE"

[makiwara]

Hi!

I have an If function which examines a cell and if contains error, then gives a value of "1" to a cell in that row.

Code:

If IsError(Cells(k1, 5).Value) = True Then
Cells(k1, 8).Value = "1"

End If

https://imgur.com/a/SB5tEBE

But it doesnt work as expected: there is a "1" in the row of cell(5,5) however the iserror function gives a FALSE value as result, so something is wrong. Any idea? Thank you for your help!

 

[Momentman]

AM not too sure of your description..but 1 is different from "1", i.e 1 as a number versus 1 as text, so depending on how you use them, you might have erroneous results

 

[makiwara]

Thank you!

AM not too sure of your description..but 1 is different from "1", i.e 1 as a number versus 1 as text, so depending on how you use them, you might have erroneous results