Results 1 to 3 of 3
  1. #1
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Multiple iif (2K3)

    My mind has gone <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>

    Here is the question:

    1) If [something] is between
    Jerry

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multiple iif (2K3)

    The discount percentage is

    IIf([something]<20,0,IIf([something]<30,0.05,IIf([something]<40,0.06,0.07)))

    Replace < with <= (less than or equal to) if required.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Multiple iif (2K3)

    Thanks Hans

    Frustratingly easy, just shows that when you do things in VB you can forget the day to day function stuff...thanks
    Jerry

Posting Permissions

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