**Question description:**

*This user has given permission to use the problem statement for this blog.*

I need a formula like if F3 is the same number as F2, then put an x in E3

Solved by Z. J. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

User
29/03/2018 - 03:03

2013

Excelchat Expert
29/03/2018 - 03:03

hi there!

Excelchat Expert
29/03/2018 - 03:04

From your problem description, it looks like you're trying to create a formula which check the previous cell to see if they are the same value?

User
29/03/2018 - 03:05

yes, and then put an x in the cell to the left

Excelchat Expert
29/03/2018 - 03:05

gotcha - i'm making a little test in our google sheet - let me know if you can see it

Excelchat Expert
29/03/2018 - 03:05

so E1 will be blank of course

User
29/03/2018 - 03:05

I can see it

Excelchat Expert
29/03/2018 - 03:06

check that out - let me know if that is what you're after

User
29/03/2018 - 03:07

I copied it in excel and all I see is the formula in the call

User
29/03/2018 - 03:07

cell

Excelchat Expert
29/03/2018 - 03:08

if you put only a "=" in the next cell down, does it prompt you to enter a formula, or does it just show a "="?

User
29/03/2018 - 03:08

It just shows =if(F3=F2,ʺXʺ,ʺʺ)

User
29/03/2018 - 03:08

in the cell

Excelchat Expert
29/03/2018 - 03:09

ok

Excelchat Expert
29/03/2018 - 03:09

can you delete that

Excelchat Expert
29/03/2018 - 03:09

and in the cell, only put a "="

Excelchat Expert
29/03/2018 - 03:09

then press the down arrow - does it prompt you to enter a formula, or does it just show the =?

Excelchat Expert
29/03/2018 - 03:10

like - if you manually type in the formula that I gave you, does it work, or just show the formula you typed?

User
29/03/2018 - 03:11

it still is showing just the formula

User
29/03/2018 - 03:11

=IF(F3=F2,ʺXʺ,ʺʺ)

Excelchat Expert
29/03/2018 - 03:12

weird! ok - can you delete that, then highlight the entire column, and right click, and then select "format cells"

Excelchat Expert
29/03/2018 - 03:12

and let me know what format is showing

User
29/03/2018 - 03:12

text

Excelchat Expert
29/03/2018 - 03:12

i think thats the issue

Excelchat Expert
29/03/2018 - 03:13

can you change the format to "General" in the cells you need to add the formula to

User
29/03/2018 - 03:13

ok

Excelchat Expert
29/03/2018 - 03:13

and then try and manually type the formula in again

Excelchat Expert
29/03/2018 - 03:13

not copy/paste (just to make sure)

User
29/03/2018 - 03:14

oh

Excelchat Expert
29/03/2018 - 03:16

it worked?

User
29/03/2018 - 03:16

you are amazing! I wish you could mentor me!!!

Excelchat Expert
29/03/2018 - 03:16

so glad it worked!

Excelchat Expert
29/03/2018 - 03:16

ping us if you need anything else later on

Excelchat Expert
29/03/2018 - 03:17

have a great rest of the day!

Excelchat Expert
29/03/2018 - 03:19

you can end this chat if you'd like - or wait 4 minutes :) take care for now -

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