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.

2 Answers 2

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")

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .