jeudi 5 mars 2020

AND and OR function in ArrayFormula

Can this be turned into an array formula for approx. a thousand cells down the column in my sheet to hopefully reduce processing lag?

IF(OR(AND(DAY($Q$42)=DAY(CP22),DAY($Q$42)<>DAY(CP23)),CU21<>""),CQ22,"")

Aucun commentaire:

Enregistrer un commentaire