Search
Search

Vectorizing logical operators in Excel

kevinykuo Published at Dev
18
kevinykuo

Suppose I have two columns

A: (TRUE, TRUE, FALSE)

B: (TRUE, FALSE, FALSE)

I want to do something like

AND(A1:A3,B1:B3) that returns (TRUE, FALSE, FALSE)

is this possible?

Dmitry Pavliv

Select, say, C1:C3, with selected cells enter formula in formula bar:

=(A1:A3)*(B1:B3)

and press CTRL+SHIFT+ENTER. Curly brackets will automatically appear at the start and end of the formula.

It produces output 1,0,0. If you want exactly TRUE/FALSE, use:

=(A1:A3)*(B1:B3)>0

also with array entry

enter image description here

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Dev

Excel Logical operators inside If loop

From Dev

Using logical operators with excel strings

From Dev

Logical AND (&&) and OR (||) operators

From Dev

Logical AND (&&) and OR (||) operators

From Dev

Logical operators

From Dev

Logical Operators and increment operators

From Dev

How do I put logical operators in an Excel =IF Formula?

From Dev

Excel array formula does not work when using logical operators

From Dev

What is the type of the logical operators?

From Dev

Logical operators with three lists

From Dev

Logical Operators in Tweepy Filter

From Dev

Precedence of the shell logical operators &&, ||

From Dev

Combining logical operators in Ruby

From Dev

Are logical operators in assertions acceptable?

From Dev

Logical operators on enums

From Dev

Gradients of Logical Operators in Tensorflow

From Dev

Increment and logical operators precedence

From Dev

If statement with no logical operators in python

From Dev

Combine multiple logical operators

From Dev

How these logical operators work?

From Dev

Logical operators confusion

From Dev

Difference in C logical operators

From Dev

Precedence of the shell logical operators &&, ||

From Dev

Are logical operators in assertions acceptable?

From Dev

Logical operators and their behavior in JavaScript

From Dev

Python regex for logical operators

From Dev

Multiple logical OR Operators in Jade

From Dev

Increment and logical operators precedence

From Dev

Javascript logical operators and assignment?

Related Related

  1. 1

    Excel Logical operators inside If loop

  2. 2

    Using logical operators with excel strings

  3. 3

    Logical AND (&&) and OR (||) operators

  4. 4

    Logical AND (&&) and OR (||) operators

  5. 5

    Logical operators

  6. 6

    Logical Operators and increment operators

  7. 7

    How do I put logical operators in an Excel =IF Formula?

  8. 8

    Excel array formula does not work when using logical operators

  9. 9

    What is the type of the logical operators?

  10. 10

    Logical operators with three lists

  11. 11

    Logical Operators in Tweepy Filter

  12. 12

    Precedence of the shell logical operators &&, ||

  13. 13

    Combining logical operators in Ruby

  14. 14

    Are logical operators in assertions acceptable?

  15. 15

    Logical operators on enums

  16. 16

    Gradients of Logical Operators in Tensorflow

  17. 17

    Increment and logical operators precedence

  18. 18

    If statement with no logical operators in python

  19. 19

    Combine multiple logical operators

  20. 20

    How these logical operators work?

  21. 21

    Logical operators confusion

  22. 22

    Difference in C logical operators

  23. 23

    Precedence of the shell logical operators &&, ||

  24. 24

    Are logical operators in assertions acceptable?

  25. 25

    Logical operators and their behavior in JavaScript

  26. 26

    Python regex for logical operators

  27. 27

    Multiple logical OR Operators in Jade

  28. 28

    Increment and logical operators precedence

  29. 29

    Javascript logical operators and assignment?

HotTag

Archive