If formula and or formula don't show expected result

I’m trying to use IF and OR together. Both of the OR statements are true (I checked them separately and it works). Combined together the IF statements show FALSE, although both of them are TRUE, and also if only one was TRUE it should’ve returned TRUE.

enter image description here

ref table:

enter image description here

IF(OR(B2072=VLOOKUP(B2072,'Ref table'!AA3:$AB$20,1,0), C2072=SEARCH("administrativ*",C2072)), "other")

Super User Asked by litalr on November 22, 2021

1 Answers

One Answer

The answer is this: what you describe CAN'T happen.

You say the result is FALSE which REQUIRES each of the OR()'s to be FALSE: NOT errors, but actual FALSE results. Yet they neither of them can ever be FALSE. They both can either be TRUE or be an error.

Specifically, the second condition can almost never be true because SEARCH() returns a number (the position the found string begins) so to EVER be TRUE, the cell would have to contain only numerals, yet the search can only give a non-error result if it has that text in it. Ergo, it can NEVER be TRUE as used and therefore will always give an error, not a FALSE. OR() returns an error in that case, not a FALSE (indeed, simply setting that portion to an "=" as a standalone formula does the same), so you could never have gotten TRUE from that half, even though you say you do in your post.

So something important must be missing, or wrong. Without more, or accurate information, no one here can help you.

Same, by the way, with the first half: it either returns TRUE (which it can, as used here, unlike the second half), or it returns an error. But never a FALSE, so as long as it is TRUE, it is not the problem. Not true? Well, an error is an error and the IF() will return an error, NOT a FALSE.

Folks want to help you, so consider your information and try to see where it's wrong or incomplete. For example, one figures the two conditions really do produce FALSE's as standalong things, so what's different in the post from the actual spreadsheet? That's a good starting point.

And either way, that second condition simply HAS to be different than posted. As used here, it can never give anything but an error not a FALSE (it could give that in other conditions, but not in these). So looking at that is a good idea. Then folks can help. They do want to.

Answered by Jeorje on November 22, 2021

Add your own answers!

Related Questions

Chrome high processor usage on Asus Tuf A15

0  Asked on December 20, 2020 by geeky-gurdeep


Lost files since renamed folder

1  Asked on December 20, 2020 by asklep


Renaming disks: from D: to F:

1  Asked on December 20, 2020 by user2925716


Windows 10 Taskbar Icons Blinking (Compressing)

1  Asked on December 19, 2020 by guy-thomas


Mysql Workbench import CSV 0 record imported

1  Asked on December 19, 2020 by zhenyu


access to Azure Active Directory

0  Asked on December 19, 2020 by sudhakar-reddy


Unable to copy in bluestacks

2  Asked on December 18, 2020 by sagar


SSH Multiple Session -> “stdin: is not a tty”

1  Asked on December 18, 2020 by mijago


Ask a Question

Get help from others!

© 2021 All rights reserved.