You need to sign in to do that
Don't have an account?

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?
IF(
ISPICKVAL(Number_in_Household__c,"1"),
Gross_Househould_Income_per_Year__c / 11,
490
)
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.
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) ,"")