Iferror formula

My formula is designed to pull entire rows of data from spreadsheet #1 onto spreadsheet #2 if the data in column D is greater than or equal to 1. This is my formula:

=IFERROR(INDEX('Bar Inventory'!C$98:C$102,SMALL(IF('Bar Inventory'!$D$98:$D$102>='Bar Order'!$A$2,ROW('Bar Inventory'!C$98:C$102)-ROW('Bar Inventory'!C$98)+1),ROWS('Bar Inventory'!C$98:'Bar Inventory'!C99))),"")

The formula was working great until I added a formula to the cells in column D on spreadheet #1. I wanted it to determine what number should be in column D rather than having to hand jam the number. My formula is:

=IF(ISBLANK(C98)=TRUE,"",IF(C98>=1,"0","1"))

Unfortunately, now rather than only pulling onto spreadsheet #2 the rows where column D is greater than or equal to 1, it is now pulling all the rows, even if D is a zero.

Either I am doing something wrong or my original formula is looking at the actual formula in column D to find a number greater than or equal to 1 rather than the result of the formula in column D.

I need help! TeriBar inventory & Order - Test File.xlsx

Thanks for the help. Unfortunately now the problem has changed. The formula adjustment results in all lines from spreadsheet #1 showing on spreadsheet #2 until data is entered in Column D. Once Data is entered in column D the ones showing less than 1 will disappear. Leaving me with just the ones showing 1 or more. Which in the long run is what I want.

However, the problem with this new version is that I have to have enough lines available on sheet #2 to accomodate everything on Sheet #1 and then when the data is entered in column D, I end up with a lot of blank lines on sheet #2. That just leaves a bunch of blank space on the report when I print out sheet #2.

Any additional insight?