Formula field and zoho.loginuserid

Formula field and zoho.loginuserid

Hello,

Can the formula field be used to display a value from another field based on the logged in user? I have multi lingual users so I'm thinking of having a single line field with the product name in Spanish and another in English, then use the formula field to display the value from the field based on who's logged in.