requirement on fields if condition

[#1]

hi

i have tried with different ways but i couldn't get exact output.this condition i need to write backed script.here need to derive contact name field.

IF(

    BTS Contact = Manager   

    )

THEN

    (WHEN PTR= MDC, Contact Name = “Juli ”

    WHEN PTR= MTR, Contact Name = “Terri”

    WHEN PTR=  Pharma, Contact Name = “Kelly ”

    WHEN PTR= Corporate, Contact Name = “Na’Tasha “ )

ELSE IF(

    BTS Contact = Solution Manager

    )

THEN

    (Contact Name = solution_manager_name)   //  solution_manager_name is field name

ELSE IF(

    BTS Contact = Project Manager

    )

THEN

    (Contact Name = project_manager) // project_manager field name

note : i need to get the data from these fields(solution_manager_name is field name,project_manager field name )

Thanks

Siddik

[sunny_talwar]

Try not to create duplicate threads please

Need clarification on if condition with two fields

requirement on if condition