I have a simple picklist "Installments Opted" with values {1,2,3,4}.
I have a Total Fee which is a currency field.
I want to create new formula field called "1st Installment Amount" which will be =
If (Inst Opted =1, 100, (if (Inst Opted=2), 60, If (Inst Opted)=3,50,40)))
I keep getting errors - Either return type error or syntax error.
This is such a simple feature but been struggling to get it to work on Zoho
I checked the forums, there are some questions that are unanswered for last 7 years!
Please respond.
Thanks