You need to sign in to do that
Don't have an account?
adougher
Need help with formula!!
The below formulas work seperately but I need to combine them and everytime I do I cannot get them to work together. Can someone please help?
if(contains( Product2.Name ,"Front Load Recycle"),if( Price_Per_Yard__c >2.00,"A",if(Price_Per_Yard__c<2.00,"B","B")),Null)
if(contains( Product2.Name ,"Front Load Waste"),if( Price_Per_Yard__c >6.00,"A",if(Price_Per_Yard__c<5.00,"C","B")),Null)
if(contains( Product2.Name ,"Front Load Recycle"),if( Price_Per_Yard__c >2.00,"A",if(Price_Per_Yard__c<2.00,"B","B")),
if(contains( Product2.Name ,"Front Load Waste"),if( Price_Per_Yard__c >6.00,"A",if(Price_Per_Yard__c<5.00,"C","B")),Null)
)
here u go...
Replace NULL from first formaula by second formula
--- alok