Excell

Discussion in 'Microsoft Excel New Users' started by Guest, Feb 28, 2007.

  1. Guest

    Guest Guest

    Does anyone no how to set a formula to do this,
    there is different ranges like 0-499,500-799,800-999 and with each range
    there is a perentage attached like 0-499=1%,500-799=2%,800-999=3%. If a price
    falls into the range need the percentage like 303=3.03 or 805=24.15. thanks
    Mike
     
    Guest, Feb 28, 2007
    #1
    1. Advertisements

  2. Guest

    Gord Dibben Guest

    =LOOKUP(B1,{0,500,800,1000},{0.01,0.02,0.03})*B1


    Gord Dibben MS Excel MVP

    On Wed, 28 Feb 2007 11:28:15 -0800, americasmattress8888
    <> wrote:

    >Does anyone no how to set a formula to do this,
    >there is different ranges like 0-499,500-799,800-999 and with each range
    >there is a perentage attached like 0-499=1%,500-799=2%,800-999=3%. If a price
    >falls into the range need the percentage like 303=3.03 or 805=24.15. thanks
    >Mike
     
    Gord Dibben, Feb 28, 2007
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Gord

    excell 2002 format cell numbers

    Gord, Feb 23, 2004, in forum: Microsoft Excel New Users
    Replies:
    1
    Views:
    448
    RagDyer
    Feb 23, 2004
  2. Guest

    Excell 2003

    Guest, Apr 3, 2004, in forum: Microsoft Excel New Users
    Replies:
    4
    Views:
    162
    Guest
    Apr 3, 2004
  3. Octavio

    Excell attachement do no shows up

    Octavio, Apr 17, 2004, in forum: Microsoft Excel New Users
    Replies:
    3
    Views:
    171
    Lady Layla
    Apr 19, 2004
  4. Guest

    Intrest calculations in eXCELL

    Guest, Jun 12, 2004, in forum: Microsoft Excel New Users
    Replies:
    3
    Views:
    180
    Norman Harker
    Jun 13, 2004
  5. Alek Luchnikov

    How to open MS Excell 2007 Sheet in MS Excell 2000???

    Alek Luchnikov, Mar 22, 2007, in forum: Microsoft Excel New Users
    Replies:
    1
    Views:
    308
    gls858
    Mar 22, 2007
Loading...

Share This Page