# Excel - IF Function Problem - Expert Solution

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

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.