Question Locked

Simple if/then/else formula in Crystal -- why getting error message?

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

This is the formula:

IF {Prt.Prt_Participation}="xx" THEN "$250,000" else
IF {Prt.Prt_Participation}="xxx" THEN "$80,000" ELSE
IF {Prt.Prt_Participation}="xxxx" THEN "$300,000" ELSE
IF {Prt.Prt_Participation}="xxxxx" THEN $100,000" ELSE
IF {Prt.Prt_Participation}="x" THEN "$35,000"

2 replies

by older mycroft

If this is a cut & paste copy of your code:

your $100,000 price range is missing an ' " '

Eh?

This discussion is closed to new replies.