IF Formula Tool Help

[arundaka03]

Hi everyone

I have the following column and trying to transform to create the desired column:

I am in the:	Seniority (desired column)
Top 25% of my organisation in seniority	Senior role
Middle 50% of my organisation in seniority	Non-senior role
Bottom 25% of my organisation in seniority	Non-senior role
Other	Non-senior role
[Null]	[Null]

I've used the Formula tool with the following formula, but unfortunately it's not transforming the "Top 25% of my organisation in seniority" to "Senior role", instead it is transforming it to [Null]. This is depicted in the column below in red text:

I am in the:	Seniority (desired column)
Top 25% of my organisation in seniority	[Null]
Middle 50% of my organisation in seniority	Non-senior role
Bottom 25% of my organisation in seniority	Non-senior role
Other	Non-senior role
[Null]	[Null]

Screenshot of my formula below: 

Can someone please help me troubleshoot my IF formula?

Thanks,

KA

[MarqueeCrew]

@arundaka03 ,

IF

IsEmpty([field]) THEN Null() ELSEIF

Left([field],3) = "Top" THEN "Senior role"

ELSE

"Non-senior role"

ENDIF

Cheers,

Mark

[arundaka03]

Thanks, Mark. I've just edited my post to make it clearer. Essentially my IF formula is not transforming the "Top 25% of my organisation in seniority" response to "Senior role", whilst every other value is transformed as desired.

Any ideas?

Thanks,

KA

[MarqueeCrew]

Did you try using the top part of my expression?

ELSEIF

Left([field],3) = "Top" THEN "Senior role"

cheers