Formula to compare numbers in 3 columns
 

I have three columns each with different numbers. Column A has only two
numbers, Column B has 7, and Column C has 5. I need to know when the numbers
in Column A and the first two numbers in both Columns B and C do not equal.
I created the formula =IF(OR(A1<LEFT(B1,2),LEFT(C1,2)),"Doesn't Equal",""),
but am getting the €œ#VALUE!€� error message. Any ideas on how to fix this?

Formula to compare numbers in 3 columns
 

=IF(OR(A1<--LEFT(B1,2),A1<--LEFT(C1,2)),"Doesn't Equal","")
--
David Biddulph

"Marie FP" wrote in message
...
I have three columns each with different numbers. Column A has only two
numbers, Column B has 7, and Column C has 5. I need to know when the
numbers
in Column A and the first two numbers in both Columns B and C do not
equal.
I created the formula =IF(OR(A1<LEFT(B1,2),LEFT(C1,2)),"Doesn't
Equal",""),
but am getting the "#VALUE!" error message. Any ideas on how to fix this?