I'm using the function as shown below

=IF(AND((COUNTBLANK(O14:AE14)<17),L140),N14*L14, "enter project")

essential =IF(AND(TRUE, TRUE), do this, else "enter project"

however, I'm getting "enter project" even if only one of the options is TRUE.

I thought the whole point of AND was that BOTH had to be TRUE?

Any ideas???

Excel 2003