Forum Discussion

RoxanneZiegler's avatar
RoxanneZiegler
Qrew Assistant Captain
3 months ago

Formula help with multiple choices

I thought I saved the one I added so if this is duplicate I apologize, I could not find my original. I want to have a formula field that says this but the , between Pacific Dunes 2 and [#of people i...
formulas
RoxanneZiegler's avatar
RoxanneZiegler
Qrew Assistant Captain
3 months ago

I tried this but the coma after Pacific Dunes 2 comes up yellow

IF(Contains([Salesroom]="Pacific Dunes 1","Pacific Dunes 2",
[Salesroom]="GS Landsend",([# of people in party]+1)*9.63
[Salesroom]="Playa Grande",([# of people in party]+1)*7.81

 

I also did it and still yellow at comma

IF(Contains([Salesroom]="Pacific Dunes 1","Pacific Dunes 2",
If(contains([Salesroom]="GS Landsend",([# of people in party]+1)*9.63)
IF(Contains[Salesroom]="Playa Grande",([# of people in party]+1)*7.81)

AdamKrzyzanek's avatar
AdamKrzyzanek
Qrew Captain
3 months ago

What about this:

IF(
   Contains([Salesroom],"Pacific Dunes 1")
        ,"Pacific Dunes 2"
   ,Contains([Salesroom],"GS Landsend")
       ,([# of people in party]+1)*9.63
   ,Contains([Salesroom],"Playa Grande")
       ,([# of people in party]+1)*7.81
)