Need excel formula help

%3CLINGO-SUB%20id%3D%22lingo-sub-2780312%22%20slang%3D%22en-US%22%3ENeed%20excel%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2780312%22%20slang%3D%22en-US%22%3E%3CP%3EHere%20is%20my%20formula%2C%20not%20sure%20what%20the%20problem%20is%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF((E1%26lt%3B2000)*AND(F1%26lt%3B1%2F1%2F2010)*AND(D1%3D0)%2C%22Weed%22)%3C%2FP%3E%3CP%3EHere%20is%20a%20snippet%20of%20that%20part%20of%20the%20spreadsheet%20and%20you%20can%20see%20it%20is%20not%20correct%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22CatalogerJeanette_0-1632441346992.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F312559iFBA879926BF201D3%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22CatalogerJeanette_0-1632441346992.png%22%20alt%3D%22CatalogerJeanette_0-1632441346992.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20am%20I%20doing%20wrong%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2780312%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2780322%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20excel%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2780322%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1165151%22%20target%3D%22_blank%22%3E%40CatalogerJeanette%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20not%20sure%20what%20you%20consider%20%22not%20correct%22%20but%20the%20formula%20you%20show%20refers%20to%20cells%20in%20row%201.%20And%20that%20are%20the%20headers%20-%20no%20numbers%20or%20dates.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

CatalogerJeanette_0-1632441346992.png

 

What am I doing wrong? 

3 Replies

@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.

 

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.

@CatalogerJeanette 

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

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