I have a picklist of options and I want to create a calculation that says,If the answer is option 1,2 or 3 for example then score it 10,5 or 1 respectively. This is how I would write the formula in Excel, please can someone help with how to write it in Zoho.
IF("CustomFieldA"=Option1,10,IF("CustomFieldA"=Option2,5,IF("CustomFieldA"=Option3,1)))
Many thanks for your help