Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2005
    Posts
    1

    Unanswered: Combine IIf statements

    Attempting to combine two separate IIf statement into one control source, adding this
    (IIf([Order Type]="special section",[curPayment]*1)))
    to this
    =(roundCC(IIf([Order Type]="membership",[curPayment]*0.2+50,[curPayment]*0.45)))

    Thanks

  2. #2
    Join Date
    Nov 2003
    Posts
    1,487
    Hmmmm.....Try this:

    =(roundCC(IIf([Order Type]="special section",[curPayment]*1,IIf([Order Type]="membership",[curPayment]*0.2+50,[curPayment]*0.45))))

    Last edited by CyberLynx; 01-18-05 at 23:49.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •