Skip to main content
Question

Need help with if statement

  • June 1, 2018
  • 0 replies
  • 16 views

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.


    This topic has been closed for replies.

    • RobIV
    • Registered
    • June 1, 2018
    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
    )
    )
    )
    • JasonJohnson
    • Registered
    • August 9, 2018
    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)






    Terms & ConditionsAccessibility statement