Filter v if statement returning different results

Help Studio
1

Hi all,

Right now I’m trying to filter a data table (from Excel) and return rows where criteria are met. In one instance I want to pull out rows where the value >= 0.1. There is 1 blank value in the column.

When I use “Filter data table” I get the correct result:
image

However when I use this if statement I only get the final 2 of the 9 expected results:
image

Anyone got any ideas what I’m missing here?

Thanks

2

Found it - and will leave this up for others as a lesson.

As I was dealing with small numbers and using cint, anything below 0.5 was being converted to 0, which is below 0.1, so wasn’t appearing. cdbl is the answer!
cdbl(row(14)) >=0.1