Need excel formula help

[CatalogerJeanette]

Here is my formula, not sure what the problem is

=IF((E1<2000)*AND(F1<1/1/2010)*AND(D1=0),"Weed")

Here is a snippet of that part of the spreadsheet and you can see it is not correct

What am I doing wrong? 

[#2]

@CatalogerJeanette 

I'm not sure what you consider "not correct" but the formula you show refers to cells in row 1. And that are the headers - no numbers or dates.

[#3]

I'm trying to write the formula that IF a book was published prior to 2000 and purchased prior to 1/1/2010 and has had zero circs I want the answer to be weed. So I have =IF((E2<2000)*AND(F2<1/1/2020)*AND(D2=0) Not quite sure how to finish it or what to change to make it work.

[#4]

@CatalogerJeanette 

Either use AND() function or multiplication but not both.

=AND(PublishYear<2000,PurchaseDate<--"1/1/2010",Circs=0)