+ Start a Discussion
likhit varmalikhit varma 

write a formula field if the salary is 15000 the loan approval amount is 3lakhs

Marry SteinMarry Stein
IF(
   salary == 15000,
   "true value", //3lakhs
   "false value //Not 3lakhs
)

 
CharuDuttCharuDutt
Hii Likhit
Try Below Formula Field Type Text
IF(Salary__c >= 15000,'Loan Approved','Not Applicable')
Please Mark It As Best Answer If It Helps Thank You!
 
Sharath SatheeshSharath Satheesh
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")

Hope this helps.
Suraj Tripathi 47Suraj Tripathi 47
Hi Likhit Varma,
Greetings!

if(salary==15000,Loan Approval="300000","")

if you find your solution mark this as the best answer.

Thank you!
Regards
Suraj Tripathi