I need to create a formula that returns a phrase if either of Map or Training check boxes are checked. here is what I have so far.
IF(OR(Selected_Map_Set_Up__c , 1), ( Selected_Training__c , 1), "You've also purchased the following, for which you will receive a separate invoice:")
1 respuesta
Heidi,
Try this:IF(OR(Selected_Map_Set_Up__C == True, Selected_Training__c == True),"You've also purchased the following, for which you will receive a separate invoice:","")
For your checkboxes, you're evaluating if they equal True (checked). You'll comma seperate both of those inside your OR statement. Then, for your IF, you need a "what to do" if it's true or false.
If either are checked, you'll show "You've also purchased the following, for which you will receive a seperate invoice:". What you didn't have was what to do if they don't have either checked. In this case, we'll display nothing.
