Help

[Abdel735]

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

[#2 · Accepted solution]

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

[#3]

Thank you! ;)

[#4]

=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

[#5]

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