lundi 9 décembre 2019

Google sheets IF with multiple conditions

This works fine, meaning it applies to the entire column.

=ARRAYFORMULA(IF(J:J > TODAY(), DATEDIF(TODAY(),J:J,"D"), "x"))

But I want to exclude the first J row which is not a date, I need to add AND so it becomes

=ARRAYFORMULA(IF(AND(ISDATE(J:J), J:J > TODAY()), DATEDIF(TODAY(),J:J,"D"), "x"))

and now it doesn't work anymore and the entire column is empty

So how to make ARRAYFORMULA work with multiple conditions ?

Aucun commentaire:

Enregistrer un commentaire