+ Start a Discussion
vinothvinoth 

Not condition in formula field

Below is the Requirement for the formula field.

 

VS1 := Type = "Spill" & Common = "1" or Common = "2";
VS2 := Type = "Injury" & InjuryType = "Death" or InjuryType= "Accident";
VS3 := Type = "Injury" &CompDis= "PPD" or CompDis= "PTD";
If(VS1 ; "fatality"; "" ) :
If(VS2 ; "permanent disability" ; "" ) :
If(VS3 ; "$100,000 US" ; "" ) :
If( !VS1 & !VS3 ; " Other fire" ; "" ) :

 

I Had designed the formula field for this requirement

 

IF((text( Type__c)=='Spill')&&((text( Common__c )=='1')||(text( Common__c )=='2')), 'fatality',
       IF((text( Type__c)=='Injury')&&(text( InjuryType__c )=='Death')||(text( InjuryType__c )=='Accident'), 'permanent disability',
                IF((text( Type__c)=='Injury')&&((text(CompDis__c)=='PPD')||(text( CompDis__c )=='PTD')), '$100,000 US', null
                        If( !VS1 & !VS3 ; "Other fire" ; "" ) :(How I can implement this IF condition inside this formula field)?
                 )
        )
)

Suresh RaghuramSuresh Raghuram

   If(NOT( VS1 & VS3) ; "Other fire" ; "" ) :(How I can implement this IF condition inside this formula field)?

try this if this answers your questuion make this as a solution