Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

nesting Iff statement

Discussion in 'Information Technology' started by Chey, Jul 28, 2006.

  1. Chey

    Chey
    Expand Collapse
    Guest

    I have this Iff statement already.
    =IIf([CTA Account]=-1,"","6216407")
    But this depends on two factors. IIF([Transportation amount] is
    null,null,"6216407")
    It has to be and/or
    Thanks
    Chey
     
  2. Loading...


  3. Ofer Cohen

    Ofer Cohen
    Expand Collapse
    Guest

    Try

    =IIf([CTA Account]=-1,"","6216407" ,IIF([Transportation amount] is
    null,null,"6216407"))


    --
    Good Luck
    BS"D


    "Chey" wrote:

    > I have this Iff statement already.
    > =IIf([CTA Account]=-1,"","6216407")
    > But this depends on two factors. IIF([Transportation amount] is
    > null,null,"6216407")
    > It has to be and/or
    > Thanks
    > Chey
     
  4. Ofer Cohen

    Ofer Cohen
    Expand Collapse
    Guest

    I'm not sure if my first post is what you are looking for, mybe it's

    =IIf([CTA Account]=-1 Or [Transportation amount] is
    null,Null,"6216407")

    --
    Good Luck
    BS"D


    "Chey" wrote:

    > I have this Iff statement already.
    > =IIf([CTA Account]=-1,"","6216407")
    > But this depends on two factors. IIF([Transportation amount] is
    > null,null,"6216407")
    > It has to be and/or
    > Thanks
    > Chey
     

Share This Page