Forum Discussion
IF Function not working
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:-
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" |
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?
- Riny_van_EekelenPlatinum Contributor
tanishakum4gailcom That link requires log in. Please provide a link that grants access without the need to log in.
- tanishakum4gailcomCopper Contributor
Riny_van_Eekelen please go ahead with the data that I have provided in my concerned post as i have non other option
- Riny_van_EekelenPlatinum Contributor
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.