Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
june_h_clarke@yahoo.comjune_h_clarke@yahoo.com 

ISPICKVAL error :(

Receiving error Error: Syntax error. Missing ')'

 

with this Ispickval statement

 

IF(
ISPICKVAL(Number_in_Household__c,"1")
  (Gross_Househould_Income_per_Year__c / 11,490)
)

 

CAn anyone help me?

Jeff TalbotJeff Talbot

IF(
       ISPICKVAL(Number_in_Household__c,"1"),

       Gross_Househould_Income_per_Year__c / 11,

       490
    )
Forza di SognoForza di Sogno

IF(
ISPICKVAL(Number_in_Household__c,"1")
  (Gross_Househould_Income_per_Year__c / 11,490)
)

 

Are you trying to divide the gross household income by 11 or by 11490?  Either way, you need a comma after the ISPICKVAL, as the previous post points out.

 

If you're dividing by 11 for Number in household = 1, and setting the value to 490 for any other 'number in household', then the previous post's formula should work.
BrianRBrianR

It's a problem with your if statement.

You need to seperate elements with a comma and you are missing the value if false.

 

IF(logical_test, value_if_true, value_if_false)

 

 

IF( ISPICKVAL(Number_in_Household__c,"1") ,  (Gross_Househould_Income_per_Year__c / 11,490) ,"")