I have a formula that will work when applied to just one cell but stops working when I try to make it an array formula so it applies down the entire column.
I am trying to check if the date in column D is today and if column A is true or false. Based on that, I want column C to read true or false.
I have tried to apply the column to each cell individually by dragging it down, and that works fine. But it will not work with an ArrayFormula.
=AND(INT(D2:D)=TODAY(),A2:A=FALSE)
When I apply ArrayForumla the result comes back FALSE
even when it should be positive.
I expect it to automatically populate each cell in the column with that formula and return the correct TRUE/FALSE
result.
Aucun commentaire:
Enregistrer un commentaire