multiple if conditions in a formula tool

[Lumjing]

I want help in achieving the below conditions. can someone please help I have attached the conditions 

[binuacs]

@Lumjing 

[atcodedog05]

Hi @Lumjing 

You can reduce the formula to like below which will have the same functionality.

Workflow:

Hope this helps : )

[Lumjing]

@atcodedog05 and @binuacs  

sorry but I spend some time working on getting the results for attached input but not getting it can you please help.  have attached the data 

Start date                           End date                  Final
Not Applicable                   9/2/2022                   9/2/2022
11/3/2022                          Not Applicable          11/3/2022
Null                                   Null                            Null
11/3/2022                          9/2/2022                  11/3/2022
8/12/2022                          9/2/2022                  9/2/2022
Not Applicable                                                   Null
                                      Not Applicable             Null

Start date	End date	Final
Not Applicable	9/2/2022	9/2/2022
11/3/2022	Not Applicable	11/3/2022
11/3/2022	9/2/2022	11/3/2022
8/12/2022	9/2/2022	9/2/2022
Not Applicable
	Not Applicable
11/6/2022

[atcodedog05]

Hi @Lumjing 

Here is my take

Hope this helps : )