Forum Discussion

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
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")))

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

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

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"
                    )
                )
             )
        )
    )
)