IF Statement Expression

[Hussein_Osseily]

Hello Everyone, 

It would be really appreciated if you can help me understand what am doing wrong;

The end result should be as follow:

If the Value of Column [Release Date] is Blank= "B703"

If the value of Column [Release Date] is not Blank and Column [Return Date] is Blank=[Destination]

If the Value of Column [Return Date] is not Blank and Column [Export Flight] is Blank=[Return Place]

If the value of Column[Export Flight] is not Blank=[Export Destination]

IFS(
ISBLANK([Release Date]), "B703" ,

AND(ISNOTBLANK([RELEASE DATE]), ISBLANK(RETURN DATE), [DESTINATION],
ISNOTBLANK([Export Flight]) ,[Export Destination] ,
AND(ISNOTBLANK([Return Place]), ISBLANK([Export Flight]), [Return Place])
)

Thank you all in advance

[WillowMobileSys · Accepted solution]

The closing parenthesis for your AND()'s are not in the correct place.  Try this instead:

IFS(
    ISBLANK([Release Date]), "B703" ,
    AND(ISNOTBLANK([RELEASE DATE]), ISBLANK(RETURN DATE)),   [DESTINATION],
    ISNOTBLANK([Export Flight]),   [Export Destination] ,
    AND(ISNOTBLANK([Return Place]), ISBLANK([Export Flight])),    [Return Place]
)

[Hussein_Osseily]

Thanks for the explanation and solution, working great