V
VRamsay
I'm using the function as shown below
=IF(AND((COUNTBLANK(O14:AE14)<17),L14>0),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
=IF(AND((COUNTBLANK(O14:AE14)<17),L14>0),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