Hi, Making a few assumptions: 1. The evaluation is for a specific value (of 15000) and not a range. If it is a range, you should use <= and >= operators in your evaluation condition. 2. The return value would be a string of "300000" or if the condition is not met, the value would be "Condition not defined". 3. API Name of the formula field: Approval_Amount__c 4. API Name of the salary field: Salary__c
The simple answer woufd be: IF(Salary__c == 15000, "300000", "Condition not defined")
Try Below Formula Field Type Text Please Mark It As Best Answer If It Helps Thank You!
Making a few assumptions:
1. The evaluation is for a specific value (of 15000) and not a range. If it is a range, you should use <= and >= operators in your evaluation condition.
2. The return value would be a string of "300000" or if the condition is not met, the value would be "Condition not defined".
3. API Name of the formula field: Approval_Amount__c
4. API Name of the salary field: Salary__c
The simple answer woufd be:
IF(Salary__c == 15000, "300000", "Condition not defined")
Hope this helps.
Greetings!
if(salary==15000,Loan Approval="300000","")
if you find your solution mark this as the best answer.
Thank you!
Regards
Suraj Tripathi