ArrayFormula boolean AND return a false positive

Elad Benda Published at Dev

21

Elad Benda

I'm trying to create a AND boolean comparison.

It gives me same when different is expected:

=ARRAYFORMULA(IF(REGEXMATCH(K10:K, Q10:Q)*REGEXMATCH(L10:L, P10:P), "Same", "Different"))

as A == A but B != ""

player0

try:

=INDEX(IF(L10:L&K10:K=P10:P&Q10:Q, "Same", "Different"))

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-07-26

Comments

0 comments

Login to comment

Related

can pcall return value of called function instead of boolean result true/false?

Return Boolean Value as TRUE or FALSE in Select (PostgreSQL/pgAdmin)

To return a percentage result from a boolean (True/False) Column using groupby in Python Pandas

function in a model that returns a boolean fails to return anything in a blade view if false

Why casting bool on boolean type return always false

Better way to return boolean

Right way to return true/false in boolean TypeScript/JavaScript method?

Return number of "false" Boolean values from an array - MobX & React

How can i return the longest continuous occurrence of "True" in Boolean, and replace other True with False?

Return Observable<boolean> to a boolean value

Pandas boolean check unexpectedly return True instead of False

Why does my Validare Zip Code(boolean) program return false?

Boolean Function Always Return False

How to return boolean in Angular

R: return one TRUE / FALSE from a group of boolean values

Should my function return False if it has to return a boolean value?

Multiple characters in a string return a false boolean when trying to find a character in the string

Python select data return boolean true-false and DELETE value true

Python - Compare number with boolean (always return false)

Scala - return a Boolean that is neither True or False

Boolean values return false always

My $model->load(Yii::$app->request->post() return boolean (false)

how to get 2 false Boolean and return true as result

The boolean return statement inside a for loop and if statement is always returning false in java

if, elif & !=, == boolean operations only return "false" with inputs

Why does this boolean expression return False?

Sequentially reduce List<Mono<Boolean>> to single Mono<Boolean>, and abort processing if any return false

Return the indices of "false" values in a boolean array

Java Boolean method return is always false

TOP Ranking

Article

HotTag

Archive