Forum Discussion

RoxanneZiegler's avatar
RoxanneZiegler
Qrew Assistant Captain
2 months ago
Solved

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)

  • 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)