Forum Discussion

Abdel735's avatar
Abdel735
Copper Contributor
Sep 06, 2022
Solved

Help

Can someone help me with this fct =IF(ISBLANK(I2);"");IF((I2>TODAY());"To anticipate";"Gate finished");IF((I2<EDATE(TODAY();1));"Priority") , i can t find the error , i get Value! error

excel
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Sep 06, 2022

    Abdel735 

    Some brackets are in the wrong places. Perhaps this way:

    =IF(ISBLANK(I2);"";IF(I2>TODAY();"To anticipate";IF(I2<EDATE(TODAY();1);"Priority";"Gate finished")))

     

4 Replies

Sort By
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Sep 06, 2022

    Abdel735 

    Some brackets are in the wrong places. Perhaps this way:

    =IF(ISBLANK(I2);"";IF(I2>TODAY();"To anticipate";IF(I2<EDATE(TODAY();1);"Priority";"Gate finished")))

     

    • Abdel735's avatar
      Abdel735
      Copper Contributor
      Sep 06, 2022
      =IF(ISBLANK(F55));"";IF(F55='TRM DB'!G1;"'TRM DB'!G6");IF(F55='TRM DB'!H1;"'TRM DB'!H6");IF(F55='TRM DB'!I1;"'TRM DB'!I6");IF(F55='TRM DB'!J1;"'TRM DB'!J6");IF(F55='TRM DB'!K1;"'TRM DB'!K6")
      I have the same problem here ^^'
      Riny_van_Eekelen
      • Riny_van_Eekelen's avatar
        Riny_van_Eekelen
        Platinum Contributor
        Sep 06, 2022

        Abdel735 Again, you have too many brackets and in the wrong places. and also some quotation marks that shouldn't be there. Perhaps the "view" below helps you structure these type of formulas. Can't guarantee that it works for you though as I can't test it without your file. Perhaps you can use the IFS function to avoid these nested IF functions. They become complicated very quickly.

        =IF(
   ISBLANK(F55);
   "";
   IF(
       F55='TRM DB'!G1;
       'TRM DB'!G6);
       IF(
           F55='TRM DB'!H1;
           'TRM DB'!H6;
           IF(
               F55='TRM DB'!I1;
               'TRM DB'!I6);
               IF(
                   F55='TRM DB'!J1;
                   'TRM DB'!J6;
                   IF(
                       F55='TRM DB'!K1;
                       'TRM DB'!K6;
                       "Something else"
                    )
                )
             )
        )
    )
)

         

Resources