New Contributor

# Need excel formula help

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?

3 Replies

# Re: Need excel formula help

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.

# Re: Need excel formula help

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.

# Re: Need excel formula help

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

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