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

:)