vendredi 24 mai 2019

How to turn this formula into an ArrayFormula so it applies down the column

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