What is wrong with this IF formula

[mfhaq77]

Hi Everyone.

I am new in Excel, so my question appears to be silly to you.

Anyway, I want to frame a simple logic with IF
IF K2=0, "Science"
IF K2=2, "Humanities"
IF K2=8, "Business"

I have made this formula
=IF(K2=0,"Science",IF(K2=2,"Humanities",”Business”))
But it is showing #Name error
Why?

What should be the correct formula?

Regards
Haque

[sandy666]

it is ok, but look at red =IF(K2=0,"Science",IF(K2=2,"Humanities","Business")) in yours formula

[FDibbins]

You could also probably do this with a vlookup...
=vlookup(K2,$X$1:$Z$3,2,0)
with X1:X3 containing the values and Z1:Z3 containing the "answer"

[mfhaq77]

it is ok, but look at red =IF(K2=0,"Science",IF(K2=2,"Humanities","Business")) in yours formula

What should be the formula, then?

[sandy666]

Also can be: =CHOOSE(IFERROR(MATCH(K2,{0,2},0),3),"Science","Humanities","Business")

[sandy666]

Formula is ok, but last quotation marks are wrong.
yours: =IF(K2=0,"Science",IF(K2=2,"Humanities",”Business”))
should be: =IF(K2=0,"Science",IF(K2=2,"Humanities","Business"))

edit:
yours quotation mark is from MS Word probably

[philaugust2004]

What should be the formula, then?

Your formula is correct but the quotes you have around business are not the right ones. I don't know what they are but replace them with the right ones and it works

[FDibbins]

Your formula is correct but the quotes you have around business are not the right ones. I don't know what they are but replace them with the right ones and it works

They probably come from a Word document

[philaugust2004]

They probably come from a Word document

You'd think Microsoft would be able to get that bit right!

[FDibbins]

look at who you are talking about