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

#### makiwara

##### Board Regular
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!

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

#### Momentman

##### Well-known Member
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

##### Board Regular
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

Replies
5
Views
57
Replies
8
Views
126
Replies
2
Views
22
Replies
4
Views
25
Replies
8
Views
86

1,127,613
Messages
5,625,848
Members
416,139
Latest member
MattBoard

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back