+ Start a Discussion
Kevin RomeisKevin Romeis 

IF formula receiving syntax error missing ')'

Hi all,

using the IF formula:  I keep receiving a missing ')' syntax error.   what am i doing incorrectly?   thanks
IF(ISPICKVAL(StageName, "nurture", IMAGE("<URL>"),
IF(ISPICKVAL(StageName, "sent to sales",IMAGE("<URL>"),
IF(ISPICKVAL(StageName, "proposal",IMAGE("<URL>"),
IF(ISPICKVAL(StageName, "Returned",IMAGE("<URL>"),
)
)
)
)
 
Shailesh DeshpandeShailesh Deshpande
I guess you are missing the at the end of each ISPICKVAL. Once you add that, you will also have to specify the value if last IF condition turns out false.
 
IF(ISPICKVAL(StageName, "nurture"), IMAGE("<URL>"),
	IF(ISPICKVAL(StageName, "sent to sales"),IMAGE("<URL>"),
			IF(ISPICKVAL(StageName, "proposal"),IMAGE("<URL>"),
				IF(ISPICKVAL(StageName, "Returned"),IMAGE("<URL>"), // value if false
)
)
)
)

Thanks,
Shailesh.