SOLVED

Help

Occasional Contributor

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

4 Replies
best response confirmed by Abdel735 (Occasional Contributor)
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")))

 

Thank you!
=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

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