**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.*