Sep 23 2021 04:57 PM
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?
Sep 23 2021 05:01 PM
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.
Sep 23 2021 05:26 PM
Sep 23 2021 05:43 PM
Either use AND() function or multiplication but not both.
=AND(PublishYear<2000,PurchaseDate<--"1/1/2010",Circs=0)