Forum Discussion

AmandaSvaleson's avatar
AmandaSvaleson
Qrew Member
7 years ago

Need help with if statement

I have a multi-conditional if statement. I have tried it both as a text and number format. I need it to be along the lines of:

if([ibo position]="marketing manager with HOS",[commercial team total],[ibo position]="Marketing manager w/o hos",[Commercial team total],[ibo position]="Platinum Marketing Manager with HOS",[Commercial Team Total],null)

I have also tried it as a case statement. The commercial team total is a number field, I need it to recognize if any of these three conditions are true I need it to return the value in the commercial team total field, otherwise nothing.


App builders
Formulas and functions
  • RobIV's avatar
    RobIV
    Qrew Cadet
    7 years ago
    You have to nest the IF statements.  Try this.

    If([ibo position] = "marketing manager with HOS", [commercial team total],
    If([ibo position]="Marketing manager w/o hos",[Commercial team total],
    If([ibo position]="Platinum Marketing Manager with HOS",[Commercial Team Total],
    null
    )
    )
    )
    • RobIV's avatar
      RobIV
      Qrew Cadet
      7 years ago
      This isn't tested in any way, so you may have to check the syntax closely.
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      7 years ago
      A shorter syntax is

      If(
      [ibo position] = "marketing manager with HOS", [commercial team total], 

      [ibo position]="Marketing manager w/o hos",[Commercial team total],

      [ibo position]="Platinum Marketing Manager with HOS",[Commercial Team Total])
  • JasonJohnson's avatar
    JasonJohnson
    Qrew Assistant Captain
    7 years ago
    Here is a Case in case

    Case([ibo position],

    "marketing manager with HOS", [commercial team total], 

    "Marketing manager w/o hos",[Commercial team total],

    "Platinum Marketing Manager with HOS",[Commercial Team Total],

    Null)