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.