Formula Based On Condition

[Aryan063007]

Dear All,

Good day to All, this is actually my first time to post in this forum. I would like to ask some help regarding the table below: I need a formula in Column D that satisfy my needs. Thank you & appreciate your inputs.


A B C D
1 Not Started Not Started FS
2 Not Started Not Started SS
3 Not Started Not Started FF
4 Not Started In Progress FS
5 Not Started In Progress SS
6 Not Started In Progress FF
7 Not Started Completed FS
8 Not Started Completed SS
9 Not Started Completed FF
10 In Progress Not Started FS
11 In Progress Not Started SS
12 In Progress Not Started FF
13 In Progress In Progress FS
14 In Progress In Progress SS
15 In Progress In Progress FF
16 In Progress Completed FS
17 In Progress Completed SS
18 In Progress Completed FF
19 Completed Not Started FS
20 Completed Not Started SS
21 Completed Not Started FF
22 Completed In Progress FS
23 Completed In Progress SS
24 Completed In Progress FF
25 Completed Completed FS
26 Completed Completed SS
27 Completed Completed FF


Result after applying formula to Column D:

A B C D
1 Not Started Not Started FS N/A
2 Not Started Not Started SS N/A
3 Not Started Not Started FF N/A
4 Not Started In Progress FS FF
5 Not Started In Progress SS FF
6 Not Started In Progress FF N/A
7 Not Started Completed FS N/A
8 Not Started Completed SS N/A
9 Not Started Completed FF N/A
10 In Progress Not Started FS N/A
11 In Progress Not Started SS N/A
12 In Progress Not Started FF N/A
13 In Progress In Progress FS FF
14 In Progress In Progress SS N/A
15 In Progress In Progress FF N/A
16 In Progress Completed FS SS
17 In Progress Completed SS N/A
18 In Progress Completed FF N/A
19 Completed Not Started FS N/A
20 Completed Not Started SS N/A
21 Completed Not Started FF N/A
22 Completed In Progress FS N/A
23 Completed In Progress SS N/A
24 Completed In Progress FF N/A
25 Completed Completed FS N/A
26 Completed Completed SS N/A
27 Completed Completed FF N/A

[Excel Fox]

Would be easier if you explained what logic to be applied.

[Aryan063007]

Thank you for your quick response. If I have in

Scenario 1: Column A: In Progress, Column B: In Progress & Column C: FS; I must get the result in Column D: FF

Scenario 2: Column A: Not Started, Column B: In Progress & Column C: FS; I must get the result in Column D: FF

Scenario 3: Column A: Not Started, Column B: In Progress & Column C: SS; I must get the result in Column D: FF

Scenario 4: Column A: In Progress, Column B: Completed & Column C: FS; I must get the result in Column D: SS

The rest scenario must get the result of N/A:

Thank you so much for your help.

Regards.

[Excel Fox]

Here's one way of doing it

=IF(OR(AND(A2&B2="In-ProgressIn-Progress",C2="FS"),AND(A2&B2="Not-StartedIn-Progress",OR(C2="FS",C2="SS"))),"FF",IF(AND(A2&B2= "In-ProgressCompleted",C2="FS"),"SS","N/A"))

[Aryan063007]

Hi Excel Fox,

Thank you so much for your help. Appreciate! Works perfectly..

Best regards.