Try this revision:
=IF(OR(A1<LEFT(B1,2)+0,A1<LEFT(C1,2)+0),"Doesn't Equal","")
The "+0" is one way to coerce the text number returned by LEFT to a real
number so that it can be compared to A1's real number.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Marie FP" wrote:
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?