Tell us what you want to do instead of posting the formula.
AND when used this way need to compare single cells and even if it did work
you can't use the whole column (D:D) in array formulas. To check multiple
cells you would need COUNTIF or SUMPRODUCT but you would be better off if
you post exactly what you want to do

--


Regards,


Peo Sjoblom

"Iona" wrote in message
...
Hello,

I was wondering if someone can help me figure out why I receive the error
message "#VALUE!" with the formula below. I am evaluating dates. Thank
you.

=IF(AND($D:$D<100%,$K:$KTODAY()),"Review
Only",""),IF(AND($D:$D<100%,$K:$K<TODAY()),"Behind
Schedule",""),IF(AND($D:$D=100%,$K:$K<$J:$J),"Comp leted
Late",""),IF(AND($D:$D=100%,$K:$K$J:$J),"Complete d Ahead of Schedule","")