0

I want a formula like this:

IF (
    (Field1 = 'Value1' AND Field2 = 'Value2')
    OR
    ( NOT (ISBLANK (Field3)))
), 
"Output1", "Output2")

This is my actual formula:

IF( 
    (FON_Membership_Status_Formula__c  = 'Active'  &&  FON_Membership_Entity__c  = 'Account')
      OR( NOT( ISBLANK(Parent_Membership__c) ) ) 
, "Member", "Non-Member")

When I check the syntax, it gives the following error:

Error: Syntax error. Missing ')'

I don't know where should I put the missing ')'. Please help.

0

What about...

IF(
  OR(
    AND(
      FON_Membership_Status_Formula__c  = 'Active',
      FON_Membership_Entity__c  = 'Account'
    ),
    NOT(ISBLANK(Parent_Membership__c))
  ),
  "Member",
  "Non-Member"
)
0
0

I changed the formula to something like this and it seems to be working now:

IF(
   AND
   (
   FON_Membership_Status_Formula__c = 'Active' && FON_Membership_Entity__c = 'Account'
   )
   || NOT( ISBLANK(Parent_Membership__c ) )
   
   ,"Member", "Non-Member")

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.