Empty Cell has value greater than 1. Why?

I have a spreadsheet called "Schedule Line 1", with a list of items that go from row 6 to 35. These rows have all formula. Some have values like 2436, 2440, etc and others they look empty, because the formula is zero, therefore, no value displayed. On a sheet within that workbook I created a formula to display these values. (eg.: =IF('Schedule Line 1'!AF9="","",'Schedule Line 1'!AF9). So it looks like this:

2369
2437
2440



2447
2422
etc...

Everything works fine.

Then, I copy these values into a different workbook and do paste special values with VBA.
I assume the blank cells between 2440 and 2447 must have values of zero, but they're not. I created a formula like =if(T24>0,1,0) and it returns 1. T24 is a blank spot between 2440 and 2447.

Any ideas why? How can I overcome this problem.

Empty cells and blank cells with zero strings are not the same. Cells with formula which return zero strings are not blanks, hence your formula returns true, which has a value of 1.
=if(T24>0,1,0)

Change it

to
=if(T24<>"",1,0)

Thank you!