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
:)