IF/AND/OR Statement - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Kimberly WargoKimberly Wargo 

IF/AND/OR Statement

Hey all, I have a formula that is not responding as intended and I think I wrote it wrong.
If any of the three below return any of the values shown I want it to score a "1".
My record shows at least two of the 3 show the correct value and it is still returning a "0".
Any suggestions are appreciated!


IF(
AND(
Risk_Rating_From_KYC_Record__c = 'Low',
OR(
Limit_Bracket__c = 'R1',
RDC_Bracket__c = 'R1')
), 1, 0)
Best Answer chosen by Kimberly Wargo
Zena TZena T
Try this:
IF( 
  OR (Risk_Rating_From_KYC_Record__c = 'Low', Limit_Bracket__c = 'R1', RDC_Bracket__c = 'R1'
   ), 1, 0)

 

All Answers

Zena TZena T
Try this:
IF( 
  OR (Risk_Rating_From_KYC_Record__c = 'Low', Limit_Bracket__c = 'R1', RDC_Bracket__c = 'R1'
   ), 1, 0)

 
This was selected as the best answer
Kimberly WargoKimberly Wargo
So the AND was not needed.. Worked perfect!
Thank you