Formula to compare numbers in 3 columns

M

Marie FP

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to compare numbers in 3 columns 3/23/08 7
Copy pair of columns 3
If then formula with multiple cells 2
Finding the proper style field and the numbered paragraph value within the style 0
Countifs formula 2
Help with an Excel formula please? 7
Paragraph numbering in Word 1
Finding the right style field in VBA 0

Top