Formula to compare numbers in 3 columns 3/23/08
Tyro,
A1 = 06
A2 = 0608NPR1
A3 = 06W500
The first two numbers in each column must equal. I would like a formula to
tell me when they don't. A1 will always be a 2-digit number, A2 and A3 will
have 7 and 5 digits, respectively. Does this help?
"Tyro" wrote:
Please give an example. Your question is simple to answer but could be
interpreted in different ways.
Tryo
"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?
|