Excel - IF Function Problem - Expert Solution

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

Hi. I do not know why but for some reason I cannot perform a simple IF function in my excel 2016. The formula goes : =IF(A1=''YES'',10,0). Is there anything checked or unchecked in the settings, that is blocking me to perform this function or?
Solved by T. H. in 12 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 29/11/2017 - 02:32
Welcome to excel got it pro
Excelchat Expert 29/11/2017 - 02:32
I'm here to help you today.
User 29/11/2017 - 02:32
Hi
User 29/11/2017 - 02:32
hI
Excelchat Expert 29/11/2017 - 02:32
as per formula there's nothing wrong with it.
User 29/11/2017 - 02:32
i need to create a formula
User 29/11/2017 - 02:32
where
Excelchat Expert 29/11/2017 - 02:32
So, tell me about your data.
User 29/11/2017 - 02:32
for example in one cell if the value is YES
Excelchat Expert 29/11/2017 - 02:33
okay. '
User 29/11/2017 - 02:33
then in the other sheet it will return 10%
User 29/11/2017 - 02:33
if its the value is NO
User 29/11/2017 - 02:33
then return 0% in the other sheet
Excelchat Expert 29/11/2017 - 02:33
hmm
User 29/11/2017 - 02:33
but for some reason
Excelchat Expert 29/11/2017 - 02:33
understood. but 10%/0% of what?
User 29/11/2017 - 02:33
no its just a description
Excelchat Expert 29/11/2017 - 02:34
oh okay.
User 29/11/2017 - 02:34
of either YES or no Answer
User 29/11/2017 - 02:34
YES = 10%
User 29/11/2017 - 02:34
NO = 0%
Excelchat Expert 29/11/2017 - 02:34
hmm
Excelchat Expert 29/11/2017 - 02:35
so the simple formula would be =if(A1="YES",10%,0)
User 29/11/2017 - 02:35
Yes
User 29/11/2017 - 02:35
that is what I tried
User 29/11/2017 - 02:35
but it throws an error
Excelchat Expert 29/11/2017 - 02:35
but this isn't working?
User 29/11/2017 - 02:35
no
User 29/11/2017 - 02:35
i think
Excelchat Expert 29/11/2017 - 02:35
tell me about the error.
User 29/11/2017 - 02:35
there is something either unchecked
User 29/11/2017 - 02:35
or checked wrong
User 29/11/2017 - 02:35
in the settings
User 29/11/2017 - 02:36
error says, not trying to type a formula?
Excelchat Expert 29/11/2017 - 02:36
no, there's no such thing about settings in excel behind the reason of a formula not working. So please tell me about the error you are getting with the formula.
Excelchat Expert 29/11/2017 - 02:37
hmm, it happens when you mistype a formula name or make error in formula syntax.
User 29/11/2017 - 02:37
you type: = 1+1, cell shows: 2#
User 29/11/2017 - 02:37
yes
User 29/11/2017 - 02:37
but I cannot
User 29/11/2017 - 02:37
even perform
Excelchat Expert 29/11/2017 - 02:38
Is it possible for you to show me your sheet?
User 29/11/2017 - 02:38
=IF(A1=''YES'',1,0)
Excelchat Expert 29/11/2017 - 02:38
the one you are working with?
User 29/11/2017 - 02:38
i cannot share the sheet unfortunately
Excelchat Expert 29/11/2017 - 02:39
that's a problem but lets try other things.
User 29/11/2017 - 02:39
pls
User 29/11/2017 - 02:39
check the sheet here
User 29/11/2017 - 02:39
it threw an error
User 29/11/2017 - 02:39
again
Excelchat Expert 29/11/2017 - 02:39
try the formula written in B1.
Excelchat Expert 29/11/2017 - 02:40
I thing its a problem with the double quote of your formula.
User 29/11/2017 - 02:40
yes
User 29/11/2017 - 02:40
how do i change
User 29/11/2017 - 02:40
it
User 29/11/2017 - 02:40
to have needed one
User 29/11/2017 - 02:40
or what is the usual shortcut
User 29/11/2017 - 02:41
for double quote
Excelchat Expert 29/11/2017 - 02:41
may be your keyboard settings is causing the problem
User 29/11/2017 - 02:41
i think so
Excelchat Expert 29/11/2017 - 02:41
so try copying the formula I wrote.
User 29/11/2017 - 02:41
as well
User 29/11/2017 - 02:41
Yep
User 29/11/2017 - 02:41
its working
User 29/11/2017 - 02:41
so you found the problem
User 29/11/2017 - 02:42
what is the usual shortcut for double quote?
Excelchat Expert 29/11/2017 - 02:42
is it working in your sheet too?
Excelchat Expert 29/11/2017 - 02:42
there's no shortcut, its a standard key of every keyboard.
User 29/11/2017 - 02:42
Yes
User 29/11/2017 - 02:42
ok
User 29/11/2017 - 02:43
i ll figure it out
User 29/11/2017 - 02:43
at least i kno
User 29/11/2017 - 02:43
w
User 29/11/2017 - 02:43
whats wrong
Excelchat Expert 29/11/2017 - 02:43
So, either you have press the key from you keyboard or try copying from another source.
User 29/11/2017 - 02:43
Thank you so much for your help
User 29/11/2017 - 02:43
And have a nice day
Excelchat Expert 29/11/2017 - 02:43
as per example you can copy the double quote from this sheet.
Excelchat Expert 29/11/2017 - 02:43
You too.
User 29/11/2017 - 02:43
ye
User 29/11/2017 - 02:43
thx
User 29/11/2017 - 02:43
:)
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.