You need to sign in to do that
Don't have an account?
Not condition in formula field
Below is the Requirement for the formula field.
VS2 := Type = "Injury" & InjuryType = "Death" or InjuryType= "Accident";
VS3 := Type = "Injury" &CompDis= "PPD" or CompDis= "PTD";
If(VS2 ; "permanent disability" ; "" ) :
If(VS3 ; "$100,000 US" ; "" ) :
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)?
)
)
)
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