OR function not working

I am trying to get this function to work:

=IF(AND(E65<$E$17,$A$17="yes"),(IFERROR(OFFSET(E67,,-$B$17,,),0))*$D$9+(IFERROR(OFFSET(E68,,-$B$17,,),0))*$D$10,0)

E17 has a value of 30 (from a dropdown list that has the options 30 and 60).

Row 65, as referred to in "E65" here, has a count of 1 to 365.

$A$17 has a drop-down list of either yes or no.

The problem is the formula above continues to return a value of 0 for everthing (even when I have yes selected in A17 and E65 is less than E17).

Any ideas what could be going on here? I can provide more info if needed.

Thanks in advance.

To make it easier to isolate the problem, I have removed the formulas in "value if true" and replaced it with 33. The formula is still returning 0 even though A17=yes and E65=4 and E17=30:

=IF(AND(E65<$E$17,$A$17="yes"),33,0)

That still returned 0.

I then changed E65 to E108 in the formula and put the same value there and it worked. It seems that because the 65 row is the header of a table that this formula wasn't in I couldn't refer to it. Just learned something new.

Thanks for your help.

Actually, I expanded the table to include that row and it still isn't using the value in E65. What's strange is I'm successfully doing comparisons with that number in other parts of the worksheet.

I've read now that table headers are referred to as text strings. Ok, now it makes sense why this wasn't working.