IF Function not working

[tanishakum4gailcom]

I have a workbook with different sheets in which I have done many Function in each sheets at one time.

I did "IF" function in a sheet but the output is wrong. IF function has satisfied all the condition as suggested in dialogue box but the same Function is not working. And with "IF" function many others are not working like COUNTIF, COUNTIFS, AVERAGEIFS, AVERAGEIF. 

the data that is not working(in case of IF) is here below:-

here I am also uploadinding the link of the workbook:-

https://onedrive.live.com/edit.aspx?resid=FF2A3C6AB841F1A1!s5be4247e25f447f4b2d2ca3c89c6ecbb&wdOrigi... 

Name	Type 1	Total	Grass Type
Bulbasaur	Grass	318	=IF(B2="Grass";"YES";"NO")
Ivysaur	Grass	405	=IF(B3="Grass";"YES";"NO"
Venusaur	Grass	525	=IF(B4="Grass";"YES";"NO"
Charmander	Fire	309	=IF(B5="Grass";"YES";"NO"
Charmeleon	Fire	405	=IF(B6="Grass";"YES";"NO"
Charizard	Fire	534	=IF(B7="Grass";"YES";"NO"
Squirtle	Water	314	=IF(B8="Grass";"YES";"NO"
Wartortle	Water	405	=IF(B9="Grass";"YES";"NO"
Blastoise	Water	530	=IF(B10="Grass";"YES";"NO"

[#2]

@tanishakum4gailcom That link requires log in. Please provide a link that grants access without the need to log in.

[#3]

@Riny_van_Eekelen  please go ahead with the data that I have provided in my concerned post as i have non other option

[#4]

@tanishakum4gailcom Well, you just mention that "the output is wrong". That's quite vague.

Perhaps you have 'Show Formulas' enabled. Then Excel just shows the formula but not the result, or you should be using a comma to separate the function arguments, or there are leading / trailing spaces in the Type 1 column. Many different reasons why the output may be wrong.

See if the attached file provides the correct output then.

[#5]

So please let me know from where can I switch this feature(SHOW FORMULA) to get the output.

[#6]

@tanishakum4gailcom 

On the Formulas ribbon, look for the 'Show Formulas' button (top right in the picture below). If it it has a dark background it enables and will show formulas. Press it again the deactivate it and Excel will show the results.

[#7]

@Riny_van_Eekelen well i did the same but nothing happens

[#8 · Accepted solution]

@tanishakum4gailcom 

Did you try changing the semi-colons into comma's? The dotted red cell borders indicate that there is a syntax error in the formula.

Did you try the file that I uploaded earlier? How do the formula's show when you open it?

[#9]

@Riny_van_Eekelen  YES IT WORKED! As I changed the semi colons into comma.

IT REALLY HELPED me a lot

Thank You so much