Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

If the values of two cells is the same then the result should be 1
Solved by K. L. in 12 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 06/04/2018 - 10:35
hi there!
User 06/04/2018 - 10:35
Hello
Excelchat Expert 06/04/2018 - 10:36
you need a formula that displays "1" if two cells have the same value?
User 06/04/2018 - 10:36
yes
Excelchat Expert 06/04/2018 - 10:36
ok perfect I can totally help with that
User 06/04/2018 - 10:36
the value can be numbers or names too
Excelchat Expert 06/04/2018 - 10:36
that was my next question :)
Excelchat Expert 06/04/2018 - 10:37
ok so check out this example in the Google Sheet window
Excelchat Expert 06/04/2018 - 10:37
actually one more thing
Excelchat Expert 06/04/2018 - 10:37
what would you want displayed if the cells are NOT the same?
User 06/04/2018 - 10:38
Zero
User 06/04/2018 - 10:38
How did you do that?
User 06/04/2018 - 10:38
This is exactly what im looking for
Excelchat Expert 06/04/2018 - 10:38
I used an IF statement - so IF the cells are the same, then put 1, if not, then put 0
Excelchat Expert 06/04/2018 - 10:38
oh amazing!
Excelchat Expert 06/04/2018 - 10:38
you can use that formula in your workbook
Excelchat Expert 06/04/2018 - 10:39
just might have to change the reference cells
Excelchat Expert 06/04/2018 - 10:39
you know what I mean?
User 06/04/2018 - 10:39
im trying the same but its not working...Im playing around with IF formula from 3 hrs
Excelchat Expert 06/04/2018 - 10:39
i'm happy to code it in your workbook directly if you'd like
User 06/04/2018 - 10:40
I want to learn it as i have quiet a few sheets where this can help...can you show me the formula on this screen--->
Excelchat Expert 06/04/2018 - 10:41
can you see the formula in the google sheet over there? ---------->
Excelchat Expert 06/04/2018 - 10:41
in the green cell
Excelchat Expert 06/04/2018 - 10:42
yeah you got it
User 06/04/2018 - 10:42
Gimme a min...let me try it on my sheet
Excelchat Expert 06/04/2018 - 10:42
take your time
User 06/04/2018 - 10:44
It worked, Damn...Now i feel like a fool, i'm not sure what i was doing wrong, I'm really surprised.
User 06/04/2018 - 10:44
Thank you for your help
Excelchat Expert 06/04/2018 - 10:44
oh glad to hear! naaa these functions can be tricky for sure
User 06/04/2018 - 10:44
Is this a free chat
Excelchat Expert 06/04/2018 - 10:44
anytime feel free to ping us back if you need more assistance
Excelchat Expert 06/04/2018 - 10:45
there is a cost to the service but I am not 100% certain if you've signed up, i believe the first one is free? but not sure if you've registered
User 06/04/2018 - 10:45
Yes this is a free trial
Excelchat Expert 06/04/2018 - 10:45
gotcha
User 06/04/2018 - 10:46
whats the cost?
User 06/04/2018 - 10:46
$9.99?
User 06/04/2018 - 10:46
Per month?
Excelchat Expert 06/04/2018 - 10:46
if you go to the Got It site the details are there for sure if you're looking to register
User 06/04/2018 - 10:46
Where are you based? US
Excelchat Expert 06/04/2018 - 10:46
I wish I could tell you!
Excelchat Expert 06/04/2018 - 10:47
no names, locations, etc.
Excelchat Expert 06/04/2018 - 10:47
typical for help desk :)
User 06/04/2018 - 10:47
Ok...No issues...Thank you once again.
Excelchat Expert 06/04/2018 - 10:47
anytime friend all the best
User 06/04/2018 - 10:47
You too...Have a great day ahead
Excelchat Expert 06/04/2018 - 10:47
you also

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.