Forum Discussion

tanishakum4gailcom's avatar
tanishakum4gailcom
Copper Contributor
Nov 26, 2023

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

https://onedrive.live.com/edit.aspx?resid=FF2A3C6AB841F1A1!s5be4247e25f447f4b2d2ca3c89c6ecbb&wdOrigin=OFFICECOM-WEB.START.EDGEWORTH&wdPreviousSessionsrc=HarmonyWeb&wdPreviousSession=65f4d161-abfa-4f7b-990a-de2e28d35b5c 

  NameType 1TotalGrass Type
  BulbasaurGrass318=IF(B2="Grass";"YES";"NO")
  IvysaurGrass405=IF(B3="Grass";"YES";"NO"
  VenusaurGrass525=IF(B4="Grass";"YES";"NO"
  CharmanderFire309=IF(B5="Grass";"YES";"NO"
  CharmeleonFire405=IF(B6="Grass";"YES";"NO"
  CharizardFire534=IF(B7="Grass";"YES";"NO"
  SquirtleWater314=IF(B8="Grass";"YES";"NO"
  WartortleWater405=IF(B9="Grass";"YES";"NO"
  BlastoiseWater530=IF(B10="Grass";"YES";"NO"
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Nov 26, 2023

    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?

      • Riny_van_Eekelen's avatar
        Riny_van_Eekelen
        Platinum 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.

Resources