Hi, I'm trying to enter a formula to display a fixed value for each named category. I'm getting error messages when I try various configurations of this statement. Any idea why it is invalid?
Thanks!
IF {Prt.Prt_Participation}="Corporate Underwriter" THEN "$250,000" ELSE
IF {Prt.Prt_Participation}="Organizational Underwriter" THEN "$80,000" ELSE
IF {Prt.Prt_Participation}="Sponsor" THEN "$300,000" ELSE
IF {Prt.Prt_Participation}="Supporter" THEN $100,000" ELSE
IF {Prt.Prt_Participation}="Ticket" THEN "$35,000"