ShowAll Questionssorted byDate Posted
june_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 Talbot

IF(
ISPICKVAL(Number_in_Household__c,"1"),

Gross_Househould_Income_per_Year__c / 11,

490
)

Forza 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.

BrianR

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

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