CODEWITHSUNDEEP
excel
Ramin Zarrinkoub
Ramin Zarrinkoub

Reputation: 13

Excel OR function does not behave as expected

I have three columns A, B and C. If column A has a value greater than 150 or B has a value greater than 95, I want C to evaluate to TRUE, else FALSE. This is my attempt:

=OR(A2>150; B2>95)

The result of this is not as I expected. For example with A = 120 and B = 78, I get TRUE, which is clearly wrong. If I write OR(120>150; 78>95), I get FALSE, as expected.

Is Excel reading A and B as strings? What is wrong here?

Upvotes: 1

Views: 39

Answers (1)

BigBen
BigBen

Reputation: 50008

You have text-that-looks-like-numbers. You can convert them to numbers like this:

=OR(--A2>150,--B2>95)

Upvotes: 1

Related Questions