0

I have a formula that does exactly what I need except for that, for now, I need to manually expand the range for which it applies.
What do I need to add so I only have this in one cell and it automatically applies for an infinite amount of rows?

=AND(D3:D=TRUE;E3:E>0;F3:F>0)
1

Use formula:

=ARRAYFORMULA((D3:D=TRUE)*(E3:E>0)*(F3:F>0)=1)

Even shorter:

=ARRAYFORMULA((D3:D)*(E3:E>0)*(F3:F>0)=1)

If you need to combine an arbitrary number of AND / OR operations, simply add (1-...) and parentheses as needed. See this.

  • Tried the short one first, it worked like a charm, thank you! – Marek Marhoul Feb 27 at 7:08
1

=ARRAYFORMULA(IF(LEN(D3:D); IF((D3:D=TRUE) * (E3:E>0) * (F3:F>0); TRUE); ))

0

  • This formula didn't work (error analyzing the formula) – Marek Marhoul Feb 27 at 7:07
  • answer updated (I forgot you are different locale...) – user0 Feb 27 at 7:15
  • 1
    This works as well now, thanks for your time and effort – Marek Marhoul Feb 27 at 9:11

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.