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 condi...
Formulas and Functions
  • 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
Nov 26, 2023

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

  • tanishakum4gailcom's avatar
    tanishakum4gailcom
    Copper Contributor
    Nov 26, 2023

    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_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Nov 26, 2023

      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.

      • tanishakum4gailcom's avatar
        tanishakum4gailcom
        Copper Contributor
        Nov 26, 2023

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

Resources