Need urgent assistance on replacing cell value based on condition

[RaviPM10]

Hi Team ,

can you please guide me in achieving below results

I'm trying achieve result base on specific cell condition 

Conditions

1. if account / group name is ‘Sun’ and locked status is F then locked status for all below account Name should be Final
2. if account / group name is ‘Sun’ and locked status is P then locked status for all below account Name should be Prelim

I' tried to use this formula 

IF [Account / Group Name] = 'Sun' AND [LockedStatus] = 'F' THEN 'Final'

ELSEIF [Account / Group Name] != 'Sun' THEN 'Final'

ELSE 'Prelim' Endif

when Locked Status is P for Sun in that scenario its working fine however when locked Status of F in that case its not giving desired output

[binuacs]

@RaviPM10 Which condition it is not working? The account/group name of locked status F is sea which is satisfying the second condition

[RaviPM10]

@binuacs  2nd condition is not working 

"if account / group name is ‘Sun’ and locked status is P then locked status for all below account Name should be Prelim'

[binuacs]

@RaviPM10 When you say All the Account Name, what does that mean, Can you provide your expected result, which will help to understand your use case better

[RaviPM10]

Please refer to attached file 

[binuacs · Accepted solution]

@RaviPM10 let me know if the attached workflow works for you