This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.
Compare 2 excel cells
Hello,
I'm trying to do a simple compare between 2 cells.
I used
=IF(A1=B1,TRUE,FALSE)
=EXACT(A1,B1)
=MATCH(A1,B1)
Nothing seems to give me the correct answers.
Please see attached. (Cells contain numbers and texts).
Any help is appreciated.
sample-compare.xlsx
I'm trying to do a simple compare between 2 cells.
I used
=IF(A1=B1,TRUE,FALSE)
=EXACT(A1,B1)
=MATCH(A1,B1)
Nothing seems to give me the correct answers.
Please see attached. (Cells contain numbers and texts).
Any help is appreciated.
sample-compare.xlsx
Asked:
3
2
2- +3
5 Solutions
What kind of result do you want?
When I try the =IF(A1=B1,TRUE,FALSE) code in Cell C1 it returns TRUE.
When I try the =IF(A1=B1,TRUE,FALSE) code in Cell C1 it returns TRUE.
There's nothing wrong with your first formula:
=IF(A1=B1,TRUE,FALSE)
Shanan212's solution would give you text for true and false instead of boolean values which you may or may not want.
But, I think the real issue is that caculations are set to manual on your worksheet (far right of Formulas tab). This means that you won't get the expected results until you recalculate the worksheet.
For typical use, it is fine to leave Excel in automatic calculation. Exceptions would be high complexity, large data sets, or transient data.
=IF(A1=B1,TRUE,FALSE)
Shanan212's solution would give you text for true and false instead of boolean values which you may or may not want.
But, I think the real issue is that caculations are set to manual on your worksheet (far right of Formulas tab). This means that you won't get the expected results until you recalculate the worksheet.
For typical use, it is fine to leave Excel in automatic calculation. Exceptions would be high complexity, large data sets, or transient data.
@hanklm - You got it. It appears that the sheet is not calculating automatically.
If I go to the cell, press F2 to edit, then press enter, the value changes.
either that, or just press F9
If I go to the cell, press F2 to edit, then press enter, the value changes.
either that, or just press F9
Ahh you have automatic calculations disabled
Goto formula Tab - Click on 'Calculation Options'
Then click on 'Automatic'
Goto formula Tab - Click on 'Calculation Options'
Then click on 'Automatic'
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
Open in new window
You are missing quotes