+ Start a Discussion
YashhYashh 

formula fields on picklist

i have created one 2 picklists so one is gender (Male/female) and second is age(0to15 and 16to60) so i want a formula that if anyone selected supposes male and he selected 0to15 so its shows value master that guy name.
if any female put 16to60 so i want to show them   Mrs


so i want help on formula fields
ShivankurShivankur (Salesforce Developers) 
Hi Yashh,

You can try using something like below:
IF(AND(ISPICKVAL(Gender__c,"Male") && ISPICKVAL(Age__c,"0to15")),'Master','') || IF(AND(ISPICKVAL(Gender__c,"Female") && ISPICKVAL(Age__c,"16to60")),'Mrs','')
You can select return type as Text or String as to get the output as 'Master' or 'Mrs'.

Hope above information helps, Please mark as Best Answer so that it can help others in the future.

Thanks.