+ Start a Discussion
ManojKumar MuthuManojKumar Muthu 

If else condition in formula field

Hi there,

I have 3 pick list field in "Opportunity Object" base on the I selection a value shoud get arrived in another field name"ARR_value__c"
1. Opportunity_Type__c: New License, License Renewal, PS-Managed Services, AMC, PS
2. License_Type__c: Annual, Perpetual, One Time
3. Payment_Terms__c: Upfront, Annual, Monthly, Milestone
 and the condition is
If(Opportunity_Type__c='New License' && License_Type__c='Annual' && Payment_Terms__c='Upfront' )
{
ARR_value__c = (Bookings__c/License_period__c)*12
}
else if(Opportunity_Type__c='New License' && License_Type__c='Perpetual' && Payment_Terms__c='Upfront' )
{
ARR_value__c = Bookings__c* 20%
}
else if(Opportunity_Type__c='New License' && License_Type__c='One Time' && Payment_Terms__c='Monthly' )
{
ARR_value__c = (Bookings__c/License_period__c)*12
}

note: Bookings__c and License_period__c are number field

TIA



 
 
Lokesh KumarLokesh Kumar
IF(TEXT(Opportunity_Type__c) == 'New License',
	IF(TEXT(License_Type__c) == 'Annual' && TEXT(Payment_Terms__c)== 'Upfront', ARR_value__c = (Bookings__c/License_period__c)*12,
		IF(TEXT(License_Type__c) == 'Perpetual' && TEXT(Payment_Terms__c)== 'Upfront', ARR_value__c  = Bookings__c* 20,
			IF(TEXT(License_Type__c) == 'One Time') && TEXT(Payment_Terms__c)== 'Monthly', ARR_value__c = (Bookings__c/License_period__c)*12,0))),0)

Try this