formula help "if statement"
I want to do something like the below but I am unsure of the all the syntax for or that part is yellow. Can someone help me so this I tried ""
If([Salesroom]="Playa Grande",[# of people in party]+1*7.81) or([Salesroom])="GS Landsend", "Pacific Dunes",[# of people in party]+1*9.63
Thank you
What is it you want to do in the end, just written out?
If field Salesroom = Playa Grande, perform one calculation, else if SalesRoom=Landsend or Salesroom= Pacific Dunes, perform a different calculation?
If so, that looks like this:
If(
[Salesroom]="Playa Grande",([# of people in party]+1)*7.81,
[Salesroom]="GS Landsend" or [Salesroom]="Pacific Dunes", ([# of people in party]+1*9.63)
)
(This assumes you want to take the number of people, add one, and THEN multiply)